Form button changes query result

[Ruegen]

I have buttons that open a form, I'd like to have each button to change the form's query result.



So if I click button high school

the criteria for that query within the form only shows the high schools

and if I click button primary school

the criteria for that query within the form only shows the primary schools

I require the form query to remain blank for when I need to see both - that way I need not make more than one form (it's the same form that opens).

This is so I can use the same form but have a different query source.

[Ruegen]

I'm thinking open form, query field

Private Sub HighSchoolButton_Click() <<<This being the button
DoCmd.SetParameter "[SchoolTypeID]=1" <<<This being the query field that is only on the form I am opening, I am not using any values from the form I was on.
DoCmd.OpenForm "frmSchools" <<<open that form
End Sub

doesn't work so far....

[pbaldy]

You can do this, and either get the value from the form or hard-code it

http://www.baldyweb.com/wherecondition.htm

[Ruegen]

You can do this, and either get the value from the form or hard-code it

http://www.baldyweb.com/wherecondition.htm

Since I want to customize value in the parameter - do I simply do this?

DoCmd.OpenForm "SecondFormName", , , "FieldName = #" & 1 & "#"

[pbaldy]

If it's a date.

"FieldName = 1"

[Ruegen]

If it's a date.

"FieldName = 1"

Mate. I could kiss you.

DoCmd.OpenForm "frmSchools", , , "SchoolTypeID = 1 "

Works

p.s. I am John Galt

[pbaldy]

p.s. I am John Galt

Where's the gulch?!