adding new records

emartel

Registered User.
Local time
Yesterday, 16:41
Joined
Jan 15, 2005
Messages
48
Hi,
I am having a problem with a form in that I can no longer add new records to it!
The data comes from a query formed of 2 tables, linked by a 1-many relationship. I can add records to both the underlying tables and the query with no problem, but in the form I can't. I get no error message when I try to add a new record, just the windows error bleep. Properties for the form are exactly as they were last time it worked properly.
I have made changes to the database since - but not to this form specifically.
Any ideas of what I might have inadvertently done?
Many thanks
 
Locked forms (that have not intentionally been locked through the properties window) usually indicate a broken relationship between the underlying tables, open the relationship window and verify the relationship...if that's OK, on a backup start removing fields from the query to see if the problem is there.
 
Last edited:

Users who are viewing this thread

Back
Top Bottom