DLOOKUP - is this what I want

[BRABUS]

I have a form [FORM - ENTER DATA] which I use to enter data about orders. This is stored in [TABLE - Enter Data]. As each entry is created it uses a combo box to pull an order number from a table called [TABLE - WR & WBS Codes] but stores this in [TABLE - ENTER Data].

[TABLE - WR & WBS Codes] contains some extra details as well which I dont display on the form. Date order recieved and date order fulfilled.

Is there a way that as I move through each record using the form that I can get this date value from the [TABLE - WR & WBS Codes] for the currently displayed order number.

i have had a look at DLOOKUP but got in a right pickle and now wonder if its even the right way to do it.

Any suggestions would be great.

 

[Dennisk]

either include this field in a query which can be used as the record source for the form.
Or use a DLookup function.

 

[BRABUS]

can you give me a clue how to do the dlookup as I have fried my brain now with repeatedly trying and i need some expert guidance

 

[KenHigg]

Go into the code editor, type in dlookup, place the cursor somewhere over/in the word and press F1 or try this:

http://msdn.microsoft.com/en-us/library/aa172176.aspx

 

[Pat Hartman]

Don't use a DLookup() at all for this purpose. Change the recordsource of your form to a query that joins the main table to the table that the DLookup() references. You can then select columns from both tables to view on the form.