Opening form with a filkter

  • Thread starter Thread starter Andy Roberts
  • Start date Start date
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
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Select from Table using Yes/No Field 5
Access Field won't show as currency in the form, shows just a number (but works fine in the query) 1
Assign Custom Navigation Pane to a Form 1
Using Linked Combo Boxes with a subform 1
Filter listbox using combo box 1
CheckBox Processing 1
Contact Picture 1
Resetting Filter (Combo Box) to All 3

Back
Top