Error on Data Entry

D

DrewBe

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?!
 
C

Carl Rapson

DrewBe said:
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?!
Click to expand...

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

Carl Rapson
 
D

DrewBe

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

John W. Vinson

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

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]
 
Top