Sudden Entry problem!!! Please help! Urgent!

[austen]

I have a linked database where I and other users are entering data. Yesterday I entered a record absolutely with no problems into all fields. Into some of the fields, on searching back to the Form the data appears missing but only from 3 fields. It now prohibits me entering the data into it for some reason. Can you help? I am the admin of the database and do not usually use it, would this make a difference? Please help?!

 

[alvechurchdata]

on searching back to the Form the data appears missing but only from 3 fields.

Is the data visible in the table? If so, there's a problem with the form.

Geoff Franklin

http://www.alvechurchdata.co.uk

 

[austen]

No the data for those particular fields is not there, but for the other fields is. Just appears to be local to 3 fields.

 

[PHV]

Check that the 3 controls in the form are bound to the respective 3 fields in the table.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[austen]

It says so. Could there be something wrong in the relationships here do you think? I can mail you a print screen of the relationships and the form would you be able to see? The fields are Operator Details(This is report submitted by on the form)/Serial No/Asset No. Some of the users appear to have opened blank records also. Not sure if this could have affected it.
It's the TBL_EDIR_Front_End_VO2 Table that has the issue.
I'm completely at a loss.

 

[Remou]

Three field for several rows?

http://lessthandot.com