Solved

Allow edit but no "new record"

Posted on 2009-07-05
2
195 Views
Last Modified: 2013-11-28
I need the form to allow me to edit the fields, these are the properties, how can I fix it to allow me to edit?
ScreenHunter-05-Jul.-05-14.52.jpg
0
Comment
Question by:MariamAlsowaidi
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 85

Accepted Solution

by:
Scott McDaniel (Microsoft Access MVP - EE MVE ) earned 250 total points
ID: 24779797
I assume by "edit the fields", you mean you want to update the Data on the form?

Your settings should allow you to Edit existing records, but not Add or Delete records.

If you cannot edit any records, then something else is causing your trouble. Is your form based on a Query? If so, is that query updateable - that is, can you open the query directly and edit records there? If you cannot, then your form won't be editable either. Common causes of non-editable queries include invalid Joins and use of aggregate/GroupBy functions.
0
 

Author Comment

by:MariamAlsowaidi
ID: 24792355
It's just a master detail form, it doesn't run on a query, the master form has a combobox where the user selects the record number to view. the detail displays the record using the shared field id.
0

Featured Post

On Demand Webinar: Networking for the Cloud Era

Did you know SD-WANs can improve network connectivity? Check out this webinar to learn how an SD-WAN simplified, one-click tool can help you migrate and manage data in the cloud.

Question has a verified solution.

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

In a multiple monitor setup, if you don't want to use AutoCenter to position your popup forms, you have a problem: where will they appear?  Sometimes you may have an additional problem: where the devil did they go?  If you last had a popup form open…
AutoNumbers should increment automatically, without duplicates.  But sometimes something goes wrong, and the next AutoNumber value is a duplicate.  This article shows how to recover from this problem.
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …

728 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