Displaying specific data in form based on 1 entry field

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

Guest

I'm not sure how to ask this. I need to design a form that has a GL# for
budget purposes. I want info about the department and description of the GL#
division to be displayed when I enter the GL#. So when I am purchasing
things for a specific GL# the info I need to make a determination as to what
their needs are are based on the department and division info that is
displayed.

I am working with Access 2003.
 
Pat Hughes said:
I'm not sure how to ask this. I need to design a form that has a GL# for
budget purposes. I want info about the department and description of the
GL#
division to be displayed when I enter the GL#. So when I am purchasing
things for a specific GL# the info I need to make a determination as to
what
their needs are are based on the department and division info that is
displayed.

I am working with Access 2003.
Click to expand...

In the AfterUpdate event of the GL# control, you can use DLookUp to fetch
associated fields from a table based on the GL#. Something like:

Me.txtDepartment = DLookUp("[department field]","[table name]","[GL#
field]=" & Me.txtGL)

Use your own control, field and table names.

Carl Rapson
 
Back
Top