I have a form based on a query and it won't let me input data

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have created a form based on a select query. The query has linked tables as
well as imported ones.
I have been able to input data directly into the form - until I tried today
and it won't let me (just the ping).
Any ideas?
Thanks
 
I have created a form based on a select query. The query has linked tables as
well as imported ones.
I have been able to input data directly into the form - until I tried today
and it won't let me (just the ping).
Any ideas?
Thanks
Click to expand...

Not all queries are updateable; queries joining local to linked tables
may be particular problems.

Normally one would use a Form with one or more Subforms to enter data
into related tables - typically the Form based on the "one" side
table, subforms based on the related tables. Might this be a solution
for your problem?

John W. Vinson[MVP]
 
Back
Top