Solved

Queries turned into forms

Posted on 2014-12-11
3
109 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
ID: 40495072
In the form design, goto the properties, and choose the data tab. In the Recordset type choose dataset (Inconsistent Updates)


Kelvin
0
 
LVL 35

Expert Comment

by:PatHartman
ID: 40495079
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
ID: 40495241
Those are checked and still having issues.  Thanks for your help
0

Featured Post

Free Tool: Postgres Monitoring System

A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.

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.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Overview: This article:       (a) explains one principle method to cross-reference invoice items in Quickbooks®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a M…
It’s been over a month into 2017, and there is already a sophisticated Gmail phishing email making it rounds. New techniques and tactics, have given hackers a way to authentically impersonate your contacts.How it Works The attack works by targeti…
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

839 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