Subform not enterable

[Robert]

I cannot enter data on a subform. The form is enabled and not locked and
the fields are enabled and not locked. Allow additions and allow edits are
both yes. Data entry is no. The main form on which the subform resides is
okay / allows entries.

This subform is bound to a saved query which has 2 queries in it. Could
that be why it won't allow data to be entered? If not, any other ideas?
Would it be worth my while to try recreating it? How about binding the form
to one table and using dlookups on the fields?

Robert

 

[Biz Enhancer]

Hi Robert,

You can just about be certain that the form is not updateable because it
is based on queries that source from multiple tables.

My suggestion is that you look at creating a temp table to edit the data
if you cannot link it directly to an existing table.

If you use a composite temp table you will probably need to clear the
table of data and pull new data in each time you wish to change the
recordset. To save the updated data back to your original tables you
would need to have a few update queries that run on form close or some
other trigger.

Alternatively, use a listbox to show existing composite data and have an
input form that pushes new data back to the tables.

HTH,

Regards,
Nick.

 

[Robert]

A temporary table could be overwritten by multiple users. What's wrong with
dlookups?

 

[Biz Enhancer]

Hi,
Nothing particularly wrong with dlookups. Given that I have no idea of
your DB structure the temp table is only a suggestion.

As I always use a separate Frontend for every user I can have temp
tables in the FE with no danger of it conflicting with another user.

There is always another way to skin the cat so the decision on how you
solve the problem really comes down to 3 things:-

1. What solution is most efficient
2. What level of programming skill is available to implement the solution
3. What level of complexity can the end user cope with.

If it fits your application there is no reason why you can't bind it to
a single table and use dlookups.

Regards
Nick.

 

[John W. Vinson]

This subform is bound to a saved query which has 2 queries in it. Could
that be why it won't allow data to be entered? If not, any other ideas?
Would it be worth my while to try recreating it? How about binding the form
to one table and using dlookups on the fields?

Some multitable queries are updateable, and some aren't. Are you trying to
update both tables or only one of them? Could you perhaps post the SQL of the
query (or queries)? Are any of the queries Totals queries or unique-values
queries - if so they cannot be updated.

John W. Vinson [MVP]

 

[ruralguy via AccessMonster.com]

I cannot enter data on a subform. The form is enabled and not locked and
the fields are enabled and not locked. Allow additions and allow edits are
both yes. Data entry is no. The main form on which the subform resides is
okay / allows entries.

This subform is bound to a saved query which has 2 queries in it. Could
that be why it won't allow data to be entered? If not, any other ideas?
Would it be worth my while to try recreating it? How about binding the form
to one table and using dlookups on the fields?

Robert

MVP Allen Browne has a good description of why queries are read only at this
link:
http://allenbrowne.com/ser-61.html