Dlookup, one more time

B

Beverly76

I know this has been answered before but I can't understand what to do from
prior postings.

I have a data entry form that is linked to a table.
When I type in the NUMBER field, I would like the DESCRIPTION to fill in
automatically on the form. The description is just for viewing. It does not
need to be stored anywhere. A separate table called "DESCRIPTIONS" holds the
item numbers and descriptions and no other fields.

I tried a text box with a DLOOKUP which did not work. I guess I need to do
an AFTER UPDATE on the NUMBER field so that the Description field on the form
is filled in ... I do not want to use combo boxes which is what I have done
in the past.
 
B

bismuth83

That sounds about right. In the Number field AfterUpdate event, you
should set the Description textbox to the result of your DLookUp using
the Number field as criteria.
 
M

Maurice

Yep you are right use the after update event.

Something like: me.textbox=dlookup("description","tablename","Number=" &
me.number)

hth
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top