codes and forms

[amy.dangas]

I'm pretty new to access however I have created a database consisting
of a table and a form. I need some help with creating a code to allow
me to enter information into a field on my form and have it fill in
the rest of the form with information from my table.

I need to use this to recall information on a particular entry using
the form I have created.

[Larry Linson]

<am********@canadatech.comwrote

I'm pretty new to access however I have
created a database consisting of a table
and a form. I need some help with creating
a code to allow me to enter information
into a field on my form and have it fill in
the rest of the form with information
from my table.

I need to use this to recall information on
a particular entry using the form I have
created.

The simplest approach to this is, in Design View of the Form, to make
certain the Control Wizard is selected on your ToolBox, and create a
ComboBox in the Form header... one of the options will be to create a Combo
into which the user can select the identification of the information and
(using code will be created by the Control Wizard) use that data to locate
the record to be displayed in the Form.

Larry Linson
Microsoft Access MVP