CODEWITHSUNDEEP
formsms-access
Simon M
Simon M

Reputation: 163

Only display new records in a MS Access continuous form

I am making a continuous form for entering data into a table. Currently the form displays all existing data entries. Is it possible to only display the initial empty entry and basically hide the existing ones?

Upvotes: 1

Views: 2206

Answers (1)

HansUp
HansUp

Reputation: 97131

If you want the form to always display only new entries, set its Data Entry property to Yes. That setting is found on the Data tab of the form's property sheet.

Alternatively, you can leave Data Entry set to No but ask for data entry mode when opening the form via DoCmd.OpenForm:

DoCmd.OpenForm FormName:="Form1", DataMode:=acFormAdd

Upvotes: 2

Related Questions