Subform data entry

[Susan Grace]

Hello,
I have a main form with subforms on it to enter data.
However, the subform won't allow me to add anything to
it, it only displays a value that is already in the table
or nothing at all. I do not want my users to have to go
into the tables to enter data, is there any way around
this???
Thanks!

 

[Van T. Dinh]

There may be a number of reasons that prevent data entry:

1. The Subform is based on a non-updateable query. Open the RecordSource
Query by itself, i.e. not through the Form/Subform and see if you can add
Records through the DatasheetView of the Query.

2. The AllowAddtions and/or AllowEdits Properties of the Form that you used
as the Subform are set to No/False.

3. The Enabled Property of the Subform*Control* is set to No/False or the
Locked Property of the same is set to Yes/True.

 

[Susan Grace]

Thanks!
I opened up the query and I believe it is because of #1 -
The Subform is based on a non-updateable query. Can this
be changed?

 

[Van T. Dinh]

See Access Help on Updatable_Query. The Help topic show a few different
ways but it depends on your Query.