Please help!!!

M

Mythos

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.
 
S

Steve Schapel

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]
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Split form 0
Crating User Form to Add Names 1
MS365 WORD: How to Create Macro Button to CLEAR ALL fields in fill-in form 1
Program buttons to create a word document 0
Help creating a search form in Access XP 0
Space at end of multi page list to accommodate new entries 1
No option to create a list in SharePoint Site 0
Possible to Combine reports to's to a single box? 0

Top