navigate between forms dynamically

[June7]

I am starting to understand what you want but I need to know a lot more about data structure and forms. I am guessing that code in some event of the user input form could accomplish. But I don't want to guess. I will have to analyze the project.

[rohini]

umm...i gave up finally and have used an option buttons as of now...
but now i wanted to use a listbox...so how do you use two listboxes such that the combined choice of the two listboxes will run a query and open a form?

[June7]

Use the listbox (or combobox) values as filter criteria for the form (or a report). Several ways to do this.

1. Build filter criteria in code and use it in the WHERE CONDITION argument of DoCmd.OpenForm (or OpenReport)

2. In form/report RecordSource refer to the controls as input parameters. Refer to this tutorial http://datapigtechnologies.com/flash...tomfilter.html

3. Set the Filter property of form with an expression that refers to the controls as parameters