New autofill question

[Guest]

I have seen numerous answers tot his question, but each time they suggest
combo boxes. I cannot use a combo box because there are too many from which
to select, so let's try again. I need to be able to manually enter drawing
numbers and have the description of that drawing along with other data
automatically fill in. The data must go into the table as a new record, not
just display it. I have a master table with all the information in it. Can't
I somehow enter the dwg number and upon tabbing from that box have the
description and other fields auto fill? Thanks.

 

[Guest]

Check this link on how to use the Dlookup function, and implement in on the
after update event of the text box

http://www.databasedev.co.uk/dlookup.html

 

[Guest]

I tried the solution from the link using DLOOKUP, but it yielded errors. It
would not recognize the database name for some reason. I followed the
identical syntax but to no avail. This should not be difficult, but it seems
there is no easy solution to such a simple sounding problem.

If you'd like to assist, I'd really appreciate it.
I have the following:
A primary table called MASTER DWG LIST with all the fileds required.
A form called NEW ENTRY which allows the user to enter the drawing number
from which I need a field called DESCRIPTION filled in.
The user then will fill in other fields as required.

Sounds simple. I should be able to extract information from the DESCRIPTION
field and put it into the new record entry from the ENTRY FORM. How hard can
that be?

Thanks so much for any additional assistance!

 

[Guest]

On the After Update event of the Try something like

Me.DESCRIPTION = DlookUp("DESCRIPTION","[MASTER DWG LIST]","[drawing number
field name in the table] =" & Me.[drawing number field name in the form])

=========================================
If the drawing number is a text field, then add single quote

Me.DESCRIPTION = DlookUp("DESCRIPTION","[MASTER DWG LIST]","[drawing number
field name in the table] ='" & Me.[drawing number field name in the form] &
"'")
=========================================

 

[Guest]

You're a lifesaver. Thank you. It appears to work just fine. Regards - Rog

On the After Update event of the Try something like

Me.DESCRIPTION = DlookUp("DESCRIPTION","[MASTER DWG LIST]","[drawing number
field name in the table] =" & Me.[drawing number field name in the form])

=========================================
If the drawing number is a text field, then add single quote

Me.DESCRIPTION = DlookUp("DESCRIPTION","[MASTER DWG LIST]","[drawing number
field name in the table] ='" & Me.[drawing number field name in the form] &
"'")
=========================================
--
Good Luck
BS"D

I tried the solution from the link using DLOOKUP, but it yielded errors. It
would not recognize the database name for some reason. I followed the
identical syntax but to no avail. This should not be difficult, but it seems
there is no easy solution to such a simple sounding problem.

If you'd like to assist, I'd really appreciate it.
I have the following:
A primary table called MASTER DWG LIST with all the fileds required.
A form called NEW ENTRY which allows the user to enter the drawing number
from which I need a field called DESCRIPTION filled in.
The user then will fill in other fields as required.

Sounds simple. I should be able to extract information from the DESCRIPTION
field and put it into the new record entry from the ENTRY FORM. How hard can
that be?

Thanks so much for any additional assistance!