Please help!!!

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have created a form that has a list box and a command button.
I want to select a data entry from the list box and then press the command
button and open an other form2(a new form that has data).
That form2 i want to show all the data that contain the selection i made in
list box 1.

How can i do this.
 
Mythos,

I assume the data in the listbox can identify the record you want, in
otherwords the bound column of the listbox is an ID number or some such.

Use a macro on your command button, with the OpenForm action. You can
nominate the Form2 in the Form Name argument of the macro, and then in
the Where Condition argument, put the equivalent of this...
[YourIdField]=[Forms]![NameOfYourForm]![NameOfListbox]
 
Back
Top