CODEWITHSUNDEEP
ms-access
xpandamonium
xpandamonium

Reputation: 13

Data Entry Form Refreshes into Old Record

I have a main form with a subform (subform is linked to an ID on the main form). I want the subform to only be a data entry form (I have already set the following settings: Data Entry = Yes | Allow Additions = Yes | Allow Deletions = No | Allow Edits = Yes). When I load the main form, the subform shows a blank form, which is what I want. My subform also has a 'New Record' button to create a new blank record for data entry. This button works fine.

The problem I encounter is when I click 'Refresh All' (on the Access menu ribbon), the first record of the subform pops up. One workaround that I've tried is to lock that entire subform once the user clicks outside of the subform. That works fine as well, however the user now encounters a problem where they haven't finished data entry, click outside of the subform, are locked out, and are now unable to edit the record they were working on.

Is there any way to stop that first record from showing up (ie: make my subform only show blank fields at all times)?

Thank you.

Upvotes: 0

Views: 93

Answers (1)

SunKnight0
SunKnight0

Reputation: 3351

If you want the subform to be data entry only don't link or bound it. Just use unbound controls and then VBA to validate your data and create the record.

There are ways to do this with a linked and bound form but the disadvantages of doing it this way far outweigh any advantages.

Upvotes: 0

Related Questions