sargturner
New member
- Local time
- Today, 08:46
- Joined
- Oct 18, 2011
- Messages
- 7
Hello,
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.
Thanks,
Ryan Turner
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.
Thanks,
Ryan Turner