Urgent - pulling record field from variable

[Jchristensen]

I have a large problem that i need to get figured out ASAP! I have a form text box (named actual cost) that needs to pull a specific record from a table

Now in this table it has multiple rows according to each job. There is a text box (Project number) that has the project that this (actual cost) box should pull from the specific row in the table.

if anyone can help me it would be the biggest help.
-Thanks
Jon

 

[FoFa]

Sounds like a job for DLOOKUP to me.

 

[Jchristensen]

ok so looking here this is a "dlookup" as i know

DLookup("[UnitPrice]", "Order Details", "OrderID = 10248")

now instead of a actual number as the "orderID" is there a way to make it pull info from another text box within the form?

could i do something like:

DLookup("[ActualCosts]", "WIP", "project = [project]")

or something like that
-Jon

 

[Bodisathva]

ok so looking here this is a "dlookup" as i know

now instead of a actual number as the "orderID" is there a way to make it pull info from another text box within the form?

if I understand correctly:

DLookup("[ActualCosts]", "WIP", "project = " & form_[COLOR="Red"]formName[/COLOR].project)

replace formName with the name of the form you wish to pull your data from, the form_ must remain as is.