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
 

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

Similar Threads

Trying to save auto-populated data in a text table 3
project variance on form 2
Guru needed-Calculations on one form? 5
Filtering in Forms 1
Exclude data from field, when another field equals a certain numbe 2
SQL data from VBA - Sort into groups via heading. 7
Changing Default in Combo Box 6
Need to copy data from 1 workbook to another based on an invoice # 3

Back
Top