Open form from list or combo box

[andrew12]

Hi,

What I want to do is click a value from a combo box or list box and open a
form or report with that record for editing or printing purposes.

I am using a form I created that acts as a cover sheet that has buttons that
direct the user to the differnt forms and reports of the database. There is
no data bound to this form.

I tried creating a list box, and on the dbl click event I pluged a macro
(openform) with the where condition coded as follows:

[Feild1]=[Forms]![NameOfCoverForm]![NameOfListBox]![Feild1]

I seem to think I am trying complex something that is very simple.

I also would like to open a report with just the one record that was
selected in the list box or possibly have a button on the second form that
would open a report with that record...

 

[Steve Schapel]

Andrew,

Try it like this:
[Feild1]=[Forms]![NameOfCoverForm]![NameOfListBox]

This would imply that the Bound Column of the listbox returns the Field1
value.