data entry on form

[Guest]

Hello - I'm new to Forms. I created a query pulling data from multiple
tables/queries and including some calculated fields. I want to show the
results of the query in a form AND allow a user to update two fields in
tables that were used in the source query. When I create the form from the
query, it doesn't allow me to update the field. I've read the help and
enabled input on the field, but it's not working. I tried to add a subform
where I linked the query to the source table where the data is stored, but I
can't get that field to show up on the form. I know this can be done, just
not how.....
Thank you in advance for your help!

 

[Allen Browne]

Beth, open the query.
Can you update the fields you want in the query?

- No: I can't update the fields in the query.
==============================
Then you won't be able to update them in the form either.
For a check list, see:
Why is my query read-only?
at:
http://allenbrowne.com/ser-61.html

- Yes: I can update the fields in the query.
==============================
In this case, it's time to examine the properties of the form. On the Data
tab of the Properties box (looking at the properties of the form, not a text
box), you need:
Allow Edits yes
Data Entry no
Recordset Type Dynaset
For the controls, the Locked property should be No, and the Enabled property
Yes.