form field just quit accepting data

  • Thread starter Thread starter Brian
  • Start date Start date
B

Brian

I have this form based on a query that gathers data from several tables. I
have used this form to enter data into the appropriate tables - now it won't
allow me to enter any data. If I go to the query the same result occurs - I
get the appropriate results but I cannot edit or enter any of the results.
If I recreate the query I get the same results - still no good.
The only thing that I can think I changed was when I restored a backup I
lost all the relationships and had to recreate them - I set most of them to
enforce ref integrity.
Any ideas
I am going to figure another way to import the data but I am curious as to
what may be going on with my old query.
Thanks
 
Sounds like you either created a non-updateable query or you didn't do
the referential integrity right.

Post your SQL statement for the query
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top