Solved

Change bound FORM to a blank new record data entry form

Posted on 2014-11-10
3
421 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

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

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

Introduction When developing Access applications, often we need to know whether an object exists.  This article presents a quick and reliable routine to determine if an object exists without that object being opened. If you wanted to inspect/ite…
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 …
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.
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…

895 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

11 Experts available now in Live!

Get 1:1 Help Now