Solved

Change bound FORM to a blank new record data entry form

Posted on 2014-11-10
3
427 Views
Last Modified: 2016-10-22
I have a form users can update and enter data for existing clients.  I have disabled the new record featu8re.  However, I want to have a "New" button on the form that will allow the form to accept information for a new client.  So, with FVBA, how do I change the opened, bound form to a new data entry form?  I know it can be done, I just can't find my code!

Sandra
0
Comment
Question by:ssmith94015
3 Comments
 
LVL 33

Accepted Solution

by:
Mike Eghtebas earned 500 total points
ID: 40433883
On the click event of that button, you can add:

Me.DataEntry =True

and have a cancle and save buttons; include the following in both:

Me.DataEntry =False

Now, if you want to set focus on the record you just entered, you can post another question for that when you done with this part successfully.

Mike
0
 

Author Closing Comment

by:ssmith94015
ID: 40433957
Thanks, this was simpler than what I actually did.
0
 

Expert Comment

by:jenise jenise barnette
ID: 41855772
My colleagues were looking for DA 2408-4 recently and were informed about a website that hosts an online forms database . If others need DA 2408-4 too , here's <code>https://goo.gl/JqUEBU</code>
0

Featured Post

Courses: Start Training Online With Pros, Today

Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

Question has a verified solution.

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

Experts-Exchange is a great place to come for help with solutions for your database issues, and many problems are resolved within minutes of being posted.  Others take a little more time and effort and often providing a sample database is very helpf…
Entering time in Microsoft Access can be difficult. An input mask often bothers users more than helping them and won't catch all typing errors. This article shows how to create a textbox for 24-hour time input with full validation politely catching …
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
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…

785 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