Dlookup

[coolcatkelso]

Hiya

I am working on 2 forms in my DB. 1 called Workorders and the other being Schedule.

What I need to do is:-

Pull the table or form field (RepairNotes) from Workorders and put it in automatically (WorkSummery) in Schedule?

The workorder form isn't open.

I currently have it as - =DLookUp("[RepairNotes]","Workorders")
But it returns the 1st record for all the schedule

Both forms are related via the WorkorderID

Is there another way I can call this field either from the form or the table and have it add to the Schedule Table?

Cheers
________
Homemade Vaporizer Bulb

 

[pbaldy]

Not sure I understand enough about what you're doing to offer a better alternative, but to get the specific record you'd need to add a criteria. Info on syntax now:

http://www.mvps.org/access/general/gen0018.htm

 

[coolcatkelso]

Hiya

Thanks for the reply

Yeah my way of explaning without the DB isn't easy lol I am sorry

I'll seeif I can express more

The form (Workorder) has a field called RepairNotes. which is a memo field.
Obvisouly each record would have different text inside.

I want to be able to send this to my other form (Schedule) which has the field called "WorkSummery" which is also a memo field

I am using a simple Dlookup command but it displays the same "RepairNotes" for all my schedule records..

Is there a way I can Use Dlookup to display the correct RepairNote per record

Hope that helps
________
Spice weed

 

[pbaldy]

You would use a criteria, as demonstrated on that link. That said, you would not normally store the same thing in 2 places like that. You would use a query with the 2 tables joined together, enabling you to return data from both.