Access 2007 Blank Record Created When Data Entry Form Is Opened.

[Rob]

I am looking for a way of preventing a blank record from being created when a
Data Entry form is opened (then closed with no information being added to the
form). There may be an easier way but I created a Delete Query that I can
have run in a macro when the form closes. How can I get it to run without
the deleteing records prompt?

Thanks in advance.

 

[Allen Browne]

Access does not create a blank record just because you move to the new
record. There must be something that is dirtying the form, i.e. assigning a
value to a bound control. For example, you might have some code in the
form's Current or Open event that is doing this.

The best solution is to find and remove the cause of the problem. You might
also want to consider marking one of the fields as Required, so Access will
not save the record if this one is blank. To do this, open the table in
design view, select a field, and set the Required property to Yes in the
lower pane of table design.

 

[Rob]

Hi Allen,

Thanks for your advice, it worked perfectly!

RJT