Solved

Change bound FORM to a blank new record data entry form

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

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

Revamp Your Training Process

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action.

Question has a verified solution.

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

In earlier versions of Windows (XP and before), you could drag a database to the taskbar, where it would appear as a taskbar icon to open that database.  This article shows how to recreate this functionality in Windows 7 through 10.
Access custom database properties are useful for storing miscellaneous bits of information in a format that persists through database closing and reopening.  This article shows how to create and use them.
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…
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…

679 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