Open form with selected records - New to Access

[Guest]

I am trying to open my form from a splashscreen and only show records that
have a blank date field. My form always opens without any records. I have at
least 30 in the table.

I tried opening from a query that I use to list these records on a report
but then I cannot add new records.

 

[Jeff Boyce]

Open the form in design view and check its properties. If the form opens
without records, it may have the Data Entry property set to Yes (providing a
form for entering new data, but not showing existing).

Another approach, and one that saves loading all the available records
"behind the form", would be to put an unbound combo box in the header of the
form. Make the source of that combo box the list of available records (just
few enough fields for a human to be able to identify which one they want).
In the combo box's AfterUpdate event, requery the form. Base the form's
source on a query that looks to the combo box to get the recordID parameter.

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[John W. Vinson]

I am trying to open my form from a splashscreen and only show records that
have a blank date field. My form always opens without any records. I have at
least 30 in the table.

Turn off the form's Data Entry property; that's what it does - lets you enter
new records but does not display old ones.

I tried opening from a query that I use to list these records on a report
but then I cannot add new records.

Correct the error in the query, then; most queries are updateable, some
aren't. Or create a new query - select your table, create a new query based on
it, and change the criterion on the date field to

IS NULL

Save the query and base your form on it.

John W. Vinson [MVP]