Go Back   Access World Forums > Microsoft Access Discussion > Forms

Thread Tools Rating: Thread Rating: 7 votes, 5.00 average. Display Modes
Old 09-10-2012, 07:48 AM   #1
Newly Registered User
Join Date: Aug 2012
Posts: 10
Thanks: 12
Thanked 0 Times in 0 Posts
kyle1234567 is on a distinguished road
Button Action in Form - Record Creation Automation

Hello, everyone:

First of all, thanks to everyone for your knowledge, experience, and willingness to help an Access novice like me!

I have a form that will be used to record incoming correspondence in a small legal office. We might get one letter from a client, or we might get 500. Across the top of the form will be three buttons:

-Add New

When the "Add New" button is pressed, I would like the form to automatically create three fields:

-Correspondence Name (e.g., "letter regarding settlement details")
-Correspondence Date
-Correspondence Notes (memo field for notetaking reasons)

The "row" on the form should be selectable so entries can be deleted, as necessary.

Finally, and perhaps most importantly, the "Add New" button should create cascading records. The data is being stored in a SQL backend. When the button is pushed for the first time, it should create fields with a "_1" appended to them; likewise for each subsequent creation.

Does this make sense? Perhaps a form like this already exists somewhere. I would appreciate your guidance on this design process.

kyle1234567 is offline   Reply With Quote

automate , button , buttons vba , create new field

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Prevent Record Creation Upon Form Exit Earl C Phillips Visual Basic 2 07-23-2012 12:51 PM
Preventing edits on a form after record creation Theguyinthehat Forms 11 09-04-2009 10:55 AM
New record creation in both main form and subform mhughey Forms 0 05-02-2006 10:50 AM
[SOLVED] Need automation tool for Save As action Dbase beginner Modules & VBA 1 04-17-2005 08:19 PM
Update Query Action Button on Form KHStump Forms 1 11-24-2003 08:41 PM

All times are GMT -8. The time now is 08:01 PM.

Microsoft Access Help
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post

Sponsored Links

Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World