Solved

access forms

Posted on 2014-09-05
3
209 Views
Last Modified: 2014-09-05
I have a form that the user can click on to add new information to a table. There is a control on the form to click if one needs to add a new entry. However I would like the records already in the table to be accessible on the form and right now they are not.  What do I need to do?
0
Comment
Question by:Serena2345
3 Comments
 
LVL 57
ID: 40306817
Take a look at the "DataEntry" property and make sure it's set to false.  You should see existing records then.

Jim.
0
 
LVL 34

Accepted Solution

by:
PatHartman earned 500 total points
ID: 40306823
On the Data tab of the form's properties dialog is an option named DataEntry.  If this option is set to Yes, the form always opens up "empty" and prepared to add a new record.  Change this to No.

If you are using the Switchboard to open the form or the DoCmd.OpenForm method, you have the option to open the form in Add or edit mode.  Choose edit.
0
 

Author Closing Comment

by:Serena2345
ID: 40306828
That did it. Thanks
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

In the article entitled Working with Objects – Part 1 (http://www.experts-exchange.com/Microsoft/Development/MS_Access/A_4942-Working-with-Objects-Part-1.html), you learned the basics of working with objects, properties, methods, and events. In Work…
QuickBooks® has a great invoice interface that we were happy with for a while but that changed in 2001 through no fault of Intuit®. Our industry's unit names are dictated by RUS: the Rural Utilities Services division of USDA. Contracts contain un…
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…
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…

863 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

24 Experts available now in Live!

Get 1:1 Help Now