Hello Everybody
Just wonder if you wonderful people could help me with this...
I would like to create a field in a form that contains a dlookup statement that looks a particular field on table "A" based, obviously, in another field from that table....no dramas here.
but, The problem that i have is that I want to capture the data displayed in that dlookup field into another table, table "B", once the form in question is closed.
Any ideas????
Just wonder if you wonderful people could help me with this...
I would like to create a field in a form that contains a dlookup statement that looks a particular field on table "A" based, obviously, in another field from that table....no dramas here.
but, The problem that i have is that I want to capture the data displayed in that dlookup field into another table, table "B", once the form in question is closed.
Any ideas????