forms and tables HELP!

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,
I need help. I have set up a form and it works okay, except that I have 3
dlookup fields. When I look at the table all the data is there except the 3
lookup fields. How do I fix this?
 
Hello,
I need help. I have set up a form and it works okay, except that I have 3
dlookup fields. When I look at the table all the data is there except the 3
lookup fields. How do I fix this?
Click to expand...

DLookUp doesn't store data, it just retrieves it.

Could you explain what your "dlookup fields" are? What is the Control
Source of each textbox? What do you see, and what do you want to have
stored in your table? What's the Recordsource of the form, for that
matter?

John W. Vinson[MVP]
 
Thank you John.
The dlookup fields are name & id number from a client table. I do not want
to have to enter the name and id number every time, so I have a lookup based
on the fac# i put in on the form. When I look at at the table there is no
data. I need to see who the client name is. Do I have to do an update query
to get the data in? Again thank you for answering my question.
 
Thank you John.
The dlookup fields are name & id number from a client table. I do not want
to have to enter the name and id number every time, so I have a lookup based
on the fac# i put in on the form. When I look at at the table there is no
data. I need to see who the client name is. Do I have to do an update query
to get the data in? Again thank you for answering my question.
Click to expand...

Again: I asked some specific questions. I'll be able to help you if
you provide specific answers.

What is the Control Source of each textbox? What do you see, and what
do you want to have stored in your table? What's the Recordsource of
the form?


John W. Vinson[MVP]
 
Back
Top