Using a WHERE clause in Docmd.openform

[dhaveedh]

I have two forms A and B. I want to open form B when I click a button in form A. This is straighforward.

What I want to do is specify a criteria in the where clause of the Docmd.openform statement. This criteria is to serve as a filter for Form B so that i only display certain records.

The two forms are based on the same table and I want Form B to open from Form A based on a criteria in the table.

Can anyone help?



KISS - Keep It Simple Sugar!

 

[PaulBricker]

What have you tried. As you say, this should be simple.


Paul