Solved

Queries turned into forms

Posted on 2014-12-11
3
106 Views
Last Modified: 2014-12-11
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
Comment
Question by:Jass Saini
3 Comments
 
LVL 22

Accepted Solution

by:
Kelvin Sparks earned 500 total points
Comment Utility
In the form design, goto the properties, and choose the data tab. In the Recordset type choose dataset (Inconsistent Updates)


Kelvin
0
 
LVL 34

Expert Comment

by:PatHartman
Comment Utility
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
 

Author Closing Comment

by:Jass Saini
Comment Utility
Those are checked and still having issues.  Thanks for your help
0

Featured Post

Get up to 2TB FREE CLOUD per backup license!

An exclusive Black Friday offer just for Expert Exchange audience! Buy any of our top-rated backup solutions & get up to 2TB free cloud per system! Perform local & cloud backup in the same step, and restore instantly—anytime, anywhere. Grab this deal now before it disappears!

Join & Write a Comment

The first two articles in this short series — Using a Criteria Form to Filter Records (http://www.experts-exchange.com/A_6069.html) and Building a Custom Filter (http://www.experts-exchange.com/A_6070.html) — discuss in some detail how a form can be…
Regardless of which version on MS Access you are using, one of the harder data-entry forms to create is one where most data from previous entries needs to be appended to new records, especially when there are numerous fields and records involved.  W…
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…

743 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now