(Msg. 1) Posted: Sun Oct 05, 2008 3:55 pm
Post subject: Value from a table show on rpt Archived from groups: microsoft>public>access (more info?)
Hello I have a report that is unbound and Im using something like:
=Forms!AccidentEntry!AccidentEntrySubform.Form!ID
in each control source. Anyway I have a text boxes that have to have a name
from a table named tblPlantInfo. The field in this table is named PM. How can
I write a function to retrieve what is tin the tables field named PM so I can
put int in the control source on my report. Thanks!
--
Thanks,
Chad
(Msg. 2) Posted: Sun Oct 05, 2008 10:39 pm
Post subject: Re: Value from a table show on rpt [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
On Sun, 5 Oct 2008 15:55:21 -0700, SoggyCashew
<SoggyCashew.RemoveThis@discussions.microsoft.com> wrote:
>Hello I have a report that is unbound and Im using something like:
>=Forms!AccidentEntry!AccidentEntrySubform.Form!ID
>in each control source. Anyway I have a text boxes that have to have a name
>from a table named tblPlantInfo. The field in this table is named PM. How can
>I write a function to retrieve what is tin the tables field named PM so I can
>put int in the control source on my report. Thanks!
(Msg. 3) Posted: Mon Oct 06, 2008 12:30 pm
Post subject: Re: Value from a table show on rpt [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
Thanks for the reply John! I got it with =DLookUp("[HR]","tblPlantInfo")
--
Thanks,
Chad
"John W. Vinson" wrote:
> On Sun, 5 Oct 2008 15:55:21 -0700, SoggyCashew
> <SoggyCashew.RemoveThis@discussions.microsoft.com> wrote:
>
> >Hello I have a report that is unbound and Im using something like:
> >=Forms!AccidentEntry!AccidentEntrySubform.Form!ID
> >in each control source. Anyway I have a text boxes that have to have a name
> >from a table named tblPlantInfo. The field in this table is named PM. How can
> >I write a function to retrieve what is tin the tables field named PM so I can
> >put int in the control source on my report. Thanks!
>
> Just guessing here...
>
> =DLookUp("PM", "[tblPlantInfo]", "[ID] = " &
> Forms!AccidentEntry!AccidentEntrySubform.Form!ID)
>
> --
>
> John W. Vinson [MVP]
>
(Msg. 4) Posted: Mon Oct 06, 2008 2:50 pm
Post subject: Re: Value from a table show on rpt [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
On Mon, 6 Oct 2008 12:30:02 -0700, SoggyCashew
<SoggyCashew.RemoveThis@discussions.microsoft.com> wrote:
>Thanks for the reply John! I got it with =DLookUp("[HR]","tblPlantInfo")
This will find the first (actually an arbitrary) record from tblPlantInfo
unless you add a criterion as a third argument. If that's what you want,
fine...
--
All times are: Eastern Time (US & Canada) (change)
Page 1 of 1
You can post new topics in this forum You can reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
Home
Forums
Home
FAQ
Profile
Private Messages
Log in
Office Other