data list

[Guest]

Hello, hopefully someone can help me.

I have a contact database with two forms. The first is "Company" then a
subform named "Individuals". When going into the subform "Individuals" I
would like to have a list of all the current individuals listed under that
company. The reason is instead of using the navigation buttons to see if
the individual is already listed under this company, I have people entering
in the name a second time. Can someone tell me how to just provide a list to
select from instead of navigation buttons?

 

[tina]

you can set up a "find" combo box in the subform, using a wizard. open the
subform in design view. make sure the Control Wizards button on the Toolbox
toolbar is "depressed". then click on the Combo Box button on the toolbar,
and click on your subform where you want the control to be.

the wizard will start. choose the third option "Find a record on my form
based on the value I selected in my combo box." then click Next, and follow
the wizard instructions to create the combo box.

set the tab order in the subform so that the combo box is first. then train
your users to do a "Find" for the contact first, when they enter the
subform.

hth