Solved

Change bound FORM to a blank new record data entry form

Posted on 2014-11-10
3
442 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

Salesforce Made Easy to Use

On-screen guidance at the moment of need enables you & your employees to focus on the core, you can now boost your adoption rates swiftly and simply with one easy tool.

Question has a verified solution.

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

This article describes a method of delivering Word templates for use in merging Access data to Word documents, that requires no computer knowledge on the part of the recipient -- the templates are saved in table fields, and are extracted and install…
Microsoft Access is a place to store data within tables and represent this stored data using multiple database objects such as in form of macros, forms, reports, etc. After a MS Access database is created there is need to improve the performance and…
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…
This is Part 3 in a 3-part series on Experts Exchange to discuss error handling in VBA code written for Excel. Part 1 of this series discussed basic error handling code using VBA. http://www.experts-exchange.com/videos/1478/Excel-Error-Handlin…

688 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