Displaying specific data in form based on 1 entry field

[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.

 

[Carl Rapson]

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.

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