Go Back   Access World Forums > Microsoft Access Discussion > Forms

Thread Tools Rate Thread Display Modes
Prev Previous Post   Next Post Next
Old 10-18-2011, 09:57 AM   #1
Newly Registered User
Join Date: Oct 2011
Posts: 7
Thanks: 0
Thanked 0 Times in 0 Posts
sargturner is on a distinguished road
Unhappy Help With Save Button

I am designing a database to keep track of people's van driving training. I have a form to add a new member to a selected class. This is supposed to save to a query where I can then see who needs to update their training and who does not. On my form I have...

Last name (text box)
First name (text box)
Date (of the course, dropdown)
Instructor (of the course, dropdown)
Location (of the course, dropdown)

I want to add the member to my table and save all of the data in a query. I created a button and embedded a macro within it to save and close the form. It works great but it is also saving the instructor and location and adding them as if they are new records to be recorded. I only want to save these in the query, not in their tables.

Please any help would be great! This is the last part of my project I need to do then it is done and its been driving me insane! Also I am not a super VBA genius.. I know the basics of it hence why I am using a macro instead of writing the code. If writing the code would be easier (im sure it would be) please give a brief explanation of it.

Ryan Turner

sargturner is offline   Reply With Quote

button , form , query , save , table

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Question How i create a Save Button and A Clear Form Button? Amenofhis General 8 08-16-2012 09:51 AM
Only save record in subform when a save button is pressed patkeaveney Forms 3 02-05-2008 03:30 PM
Save button NewfieSarah General 7 11-02-2005 11:22 AM
Save Button versus Save safety net monkeytunes Modules & VBA 8 09-01-2004 12:17 PM
Combine custom save button on subform with save button on main form popeye Forms 2 08-27-2004 07:58 AM

All times are GMT -8. The time now is 01:26 AM.

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