Next Record command creates new record.

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

Guest

AGH It happened again!

When clicking the next record button at the end of the recordset, it
automatically puts in the linked cust_id field. Not the "You cant go
to the specified record" error message you normally get. I think it is
automatically adding some data to a feild on the form somewhere which is
creating the record. Any ideas?

Sorry for the double post but the other one seemed fixed and closed.
HELLLLLP! :)
 
Sorry guys,
I had code in the on_current event of the form that was putting a zero
length string into one of the fields, so I couldn't see it as a value in the
table or form view, Removed that bit of silly code and all sweet. Went
shopping and realised it has to be code as it happened when i pasted from the
previous form. ALso realised it had to be either a on_current or on_load
event to happen straight away without any user interaction.

Cheers
Dylan.
 
Back
Top