One Form, different queries

[AlanJKiwi]

Hi,
I currently have 3 identical versions of a form (showing application data).

These forms each get their data from 3 separate queries.



One that shows all data from two tables.
One that shows the above but filtered by year.
One that shows the above but also filtered to show only approved applications.

I feel there must be an easier way then having 3 separate forms.

Is there a way to just have 1 form, that links to one of the 3 queries depending on what button the user selects to open the form?

Any help would be most appreciated.
AJ

[ssanfu]

Sure.

Using the form that displays all records, you could add a text box for the year (if you want to be able to change the year), some way option group (for approved or all) and 2 buttons.

One button has code to remove the filter.
The other button has code in the click event to create a filter string "on the fly".
The code checks to see if there is a year entered and/or if only approved records should be returned.

It would look something like this : http://allenbrowne.com/ser-62code.html

[trevor40]

yes, use 3 buttons each with thier own vba for the onclick event

button_1_OnClick()
me.recordsource = "your query name"
me.refresh
end sub

[AlanJKiwi]

Hi Steve,
thanks for the quick reply and the info.
A bit beyond my abilities at the mo. But i'll see if i can make it work just for my own education.
AJ

[AlanJKiwi]

Cool, thanks Trevor.
That did the trick.
AJ