Open a form with selected data

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to refresh my memory with Access. I am trying to have my form
open with records that are pulled from a table based on a date field that is
blank. The records with a blank date are the records that are active.

When I open the form from the database window gives me all the records. When
I open the form from a splashscreen it gives me no reocrds.
 
if I understand you - you want the form to open to those records with a blank
in the specific field....

for this; create a query with all the fields....in the specific field put in
the criteria: Is Null

this query when tested should now return only those records with blank
fields that column...

once you have the query working right...then go to your form in design view
and change its record source to this new query...
 
Back
Top