LOCATE NEW RECORD

[desikan]

I have a form which opens with a new record and the user makes entries. Now for safety reasons, I have made an append query ( which starts on afterupdate of the form) to append this new record to a backup Table on the same db.

Now as there is no primary index in the table on which the form is based and also other fields have duplicate entries, I am unable to put suitable filter in the query.

Hence I have put a dummy ref no in the form to filter out the new record that has been entered.

I just want to know if there is any other better method to locate this new record??

Thanks in advance.

 

[Frink]

Hallo,

Not totally sure, but have you considered using an unbound form to do your data entry, and an 'Enter' button to create the record.

- Frink

 

[gol4]

Frink offers the best solution however take a look at the last modified property to see if that is of any use to you. Access help has a decent example on its use.