Problem with DLookup

[JB83]

Dear reader(s),

I have a problem with a DLookup value. I would like to use the value of a DLookup value to create a new record into another table. Is it true that if there is no control source for a DLookup value it cannot be given to another variable and if yes, how can this problem be solved?

Thanks in advance,

Jochen.

 

[fkegley]

I think I would assign the results of my DLookup operation to a text box and attach code to the After Update event of the text box that opens the table and adds the new record. Frank kegley
fkegley@hotmail.com

 

[JB83]

Frank,

Thanks for your quick answer, I will try it!

Jochen.

 

[JB83]

Only 5 minutes after the previous post I've found a solution . . . Let's leave it on a bad start of the week

Thanks for your help anyway and keep up the good work!



Jochen. It never hurts to help and it never helps to hurt.