Where Condition

  • Thread starter Thread starter daisy
  • Start date Start date
D

daisy

I am creating a command button on a form so that when it
is clicked, it opens another form. But I am having
trouble with the Where Condition in the SQL statement for
that button. I want the second form to open but only
give me records where the field "grade" is equal to 6.
How do I write that? Thanks!
 
daisy said:
I am creating a command button on a form so that when it
is clicked, it opens another form. But I am having
trouble with the Where Condition in the SQL statement for
that button. I want the second form to open but only
give me records where the field "grade" is equal to 6.
How do I write that? Thanks!
Click to expand...

DoCmd.OpenForm "FormName",,,"grade = 6"
 
Back
Top