Unbound Forms - Refreshing!!

[mousemat]

Hi all, not been here for a year or two, hence i have forgotton a lot of Access stuff.

I have an unbound Data Entry form which when populated, adds the record to the table. Simple enough.

I have some code on the form which basically stops the user entering a new record without having a First Name and a Last Name. This code works well.

I also have some code which confirms that the user wishes to add the record to the table. If Yes, the record is added to the table but when entering data for the next record, the first code doesn't kick in about having a First Name and last name, however the Confirm Add record code kicks in.

How can I solve this, I have tried the me.refresh command in various places but as yet to no avail. Hopefully someone will point me in the right direction.

I have added the DB in both A2k and Access 2003 Versions

 

[ghudson]

You need to use the forms BeforeUpdate event to run your "validation" checks in [not your custom Save record button]. Cancel the event if the user fails your validation test to prevent the record from be saved. Search around for there are lots of posts on this subject.