Opening form with a filkter

A

Andy Roberts

I have data imported that requires assigning to a category. What I want to
do is hit a button which opens a form and displays only the data which
doesn't have a category assigned. The user can then assign a category ther
and then

Andy
 
G

Graham R Seach

Andy,

The DoCmd.OpenForm method has a WhereCondition argument:
DoCmd.OpenForm "frmFormName", , , "somefield <> 123"

Just specify the criteria you want met when opening the form.

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia
 
Top