Auto-populate data in a form based on data entered in a form

  • Thread starter Thread starter mthoms
  • Start date Start date
M

mthoms

Hi,

So I know very, very little about computers, but have created a database
anyway for my job. I have created a form. When I populate one field in the
form, I would like saved information to populate some of the other parts of
the form. For example, two of my fields are "Institution" and "State." When
I type in "New York University," I would LOVE IT if the State field populated
to "NY." All fields are either "Text" or "Memo." Any ideas? Thanks a lot in
advance.
 
you can do this with the tables.

create a table for dropdown menu purposes called universities with fields
for all the details about each university to include the state.
in the main table for capturing your primary data collection, you can have
the field labeled university be linked by lookup settings to the university
table.

unless you really want to see it, you will not need to see the state on the
form. after capturing your data from the form, you can create queries to
link the data for printing to reports.
 
Back
Top