• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 120
  • 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

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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