Error on Data Entry

[Guest]

I have a form that I've been designing... and for some reason, all at once,
it beeps back when I try and update records or input data. I'm unable to
make any changes in this form view? Help me please?!

 

[Carl Rapson]

I have a form that I've been designing... and for some reason, all at once,
it beeps back when I try and update records or input data. I'm unable to
make any changes in this form view? Help me please?!

What is the Record Source of the form? Are the form's AllowEdits and
AllowAdditions properties set to True?

Carl Rapson

 

[Guest]

Carl ... Thanks for the interest...
Yes they are set to true and my source is a query that brings in ALL tables...

 

[John W. Vinson]

Yes they are set to true and my source is a query that brings in ALL tables...

Did you recently change the query? Not all queries are updateable, and
multitable queries in particular may not be. It's VERY rarely necessary or
appropriate to base a form on a query linking all your tables! Typically one
would base the form on a query of *one* table, the "ONE" side table in your
one to many relationships; you'ld put combo boxes on the form for lookup
tables, and Subforms for "child" tables.


John W. Vinson [MVP]