Select from a List Box (Access 2K)

[mattworkgeek]

I have a couple of questions that I hope someone can answer.

1) I have a listbox on a form (List1 on Form1) that contains a list of account numbers generated from a table.

What I would like to do is to double click an account number in the listbox, an this then opens a different form containing that account information (Form2)

2) I would also like to disable the scroll buttons that appear automatically at the bottom of the forms

 

[Adrianna]

Okay...fairly simple....


First....when you create the list box you can select the third option which allows you to autofill a form or subform with records based upon your selection

Or

Use the selection in your list box to provide the criteria for a query that will be the record source of the second form!
Citeria for the primary or key field should be set to Primary1=Froms!NameForm2!Primary2


To remove the scroll buttons or navigational options from the botton:
Select the Form Properties, and set Scroll Bars to Neither and Navigational Buttons to NO

Good luck!