Access newbie help with linking Multiple tables to one form

[basco81]

In a database I am creating, the client wishes to be able to change the title of the form and report by clicking a control button on the form. I have it set up so far that when they click this button another form pops up and allows them to enter the info into a set of text boxes, which are linked to a table exculsivly for these boxes. My question is how do I link the text boxes in the original form(which has a different table linked to it) to the new table?

 

[basco81]

Just to let you guys know, I am trying the format of =[tblLabels]![Customer] in the text box to attemt to link it in the new table but can't seem to get it to work. Is there something wrong with my syntax??

Please help!!...

 

[PHV]

Take a look at the DLookUp function.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[basco81]

Thank You so much...It is working like a charm now. Didn't even think a/b using that intill you reminded me.