Opening a form from a command button

[eavan]

Hey guys,

i am clicking a command button which opens a form up.
Problem is this form was setup based on a query and therefore it is looking for query details. The user of the system will select some details on a listbox and click this button. I have this statement in the onClick property,[Case number]=[Forms]![Assigned test list]![List0], but the query is looking for the same details.I want to stop this form query prompt coming up.How do i do this would you know. Basically, the selection in the listbox ought to be the query condition criteria.Thanks

 

[fneily]

Place [Forms]![Assigned test list]![List0] on the criteria line of your query. By the way, for this to work, the form must stay open.

 

[Knicks]

As Fneily said,

Set the On Open property of the opening form

Forms![assigned test list].Visible = False


Then for the opening form, the On Close property

DoCmd.Close acForm, "assigned test list