Loosing records and important data

[Jaspal]

Hi,

We have a in house system that has a client side front end that is used by many memebers of staff. The backend data is held on the server and hence the front end uses linked tables. The problem that we are having is that when a user inputs a new record (which is very often) the record is lost, and is as though it has been deleted or never stored within the database.

The table where the data goes has a primary key which is an autonumber. however this autonumber and primary key is purely used for indexing purposes.

has anyone ever had this problem or know how to reolve the problem. we have tried writing code to force a 'save' for the new record but the problem still occurs. The problem doesnt occur all the time as majority of the time the records are saved and sat in the table, but occsionally we seem to be loosing records.

Please Help

regards

Jas

 

[Mile-O]

How do users exit the form after they have entered data?

 

[Jaspal]

They simply close the form down, using the cross in the top right hand corner.

 

[Mile-O]

Any code attached to the form?

 

[Jaspal]

there is an on load event which locks some fields. Then there is an on close event which just run an append query to transfer some data in to another table from the source behind the form in question.

 

[Mile-O]

Can you post the code?

 

[Jaspal]

Private Sub Form_Close()
'appends new company numbers in to tbl_company_v_gabemref
DoCmd.OpenQuery "qry_append_smcreg"
End Sub


this is the on close query that runs. The on load code is just siple locking of fields that are password protected!