Opening Internet Explorer submits incomplete record

J

JLotz

I have created an Access 2003 database using a subform with fields as a data
entry point. I created a command button that serves as a trigger to submit
the record to the table, basically it skips to a new record. To ensure that
all of the fields are completed, I have used coding to display a message
indicating all fields are not complete.

My problem is that if I have the subform open with an incomplete record (not
all fields completed) and I open Internet Explorer, it will skip to a new
record and bypass my coding. The anticipated messages are never activated.
 
J

JLotz

Pieter,
I copied all my checks to the Form_BeforeInsert event. When explorer is
opened, an incomplete event is still submitted. Any other thoughts?
I wonder what information is transmitted when the explorer window is opened
that interacts with the Access database.
 
Top