Opening Internet Explorer submits incomplete record

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Updating tables when you input new data 0
What strategy to add a new record on subform? 2
copy/paste records into different sheets by status 4
Report of completion status of records in bundle 4
Open form for record selected in subform 2
How To Send Record via email 5
Access Dcount (multiple criteria) 3
Click on List box and move to that record in the form 2

Back
Top