Pulling Data from tables to prefill sections of a form

M

myztiques

Help!! I want to set up a form that will require some Data to be entered and
the other parts to auto fill in when the record number is entered.

For example:

To access the Form you enter the id# and when the form opens the persons
name, program, and some other data is in the related fields and then there is
other fields that will need to be completed such as the case manager, date,
and status.

Any Suggestions???
 
C

Carl Rapson

myztiques said:
Help!! I want to set up a form that will require some Data to be entered
and
the other parts to auto fill in when the record number is entered.

For example:

To access the Form you enter the id# and when the form opens the persons
name, program, and some other data is in the related fields and then there
is
other fields that will need to be completed such as the case manager,
date,
and status.

Any Suggestions???
Click to expand...

Assumptions: the form is bound to the table/query that contains the fields
you are interested in, and you are opening the form with the DoCmd.OpenForm
method. If these assumptions are true, try this:

DoCmd.OpenForm "form name",,,"[ID]=" & myIDvalue

[ID] should be the name of the id# field in the table/query, and myIDvalue
should be the name of the control into which the id# is entered.

Carl Rapson
 
Top