• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 124
  • Last Modified:

Queries turned into forms

I have a query that I used to pull info from two tables.  The query is a simple query and I can edit the query once I run it.  The problems happens when I try to pull the info from the qery into a form.  I am unable to do any data entry??  I am not sure what I am doing wrong.  Help
0
Jass Saini
Asked:
Jass Saini
1 Solution
 
Kelvin SparksCommented:
In the form design, goto the properties, and choose the data tab. In the Recordset type choose dataset (Inconsistent Updates)


Kelvin
0
 
PatHartmanCommented:
Make sure you are using the correct query as the form's RecordSource.

The recordsetType should be Dynaset although in some rare cases you might need to use - Dynaset (Inconsistent Updates).  Snapshot recordsets are NOT updateable.

Check the "Allow" properties on the Data tab of the form's Property Sheet to make sure that you have allowed edits.
0
 
Jass SainiAuthor Commented:
Those are checked and still having issues.  Thanks for your help
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now