Solved

Change bound FORM to a blank new record data entry form

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

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

Most if not all databases provide tools to filter data; even simple mail-merge programs might offer basic filtering capabilities. This is so important that, although Access has many built-in features to help the user in this task, developers often n…
I see at least one EE question a week that pertains to using temporary tables in MS Access.  But surprisingly, I was unable to find a single article devoted solely to this topic. I don’t intend to describe all of the uses of temporary tables in t…
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.

743 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

10 Experts available now in Live!

Get 1:1 Help Now