Polopudding
New member
- Local time
- Today, 03:07
- Joined
- Jul 24, 2021
- Messages
- 4
I´m a bit of a novice with VBA and I think I´m biting off more than I can chew. I am creating a bookings application. On the booking form I can look up members, however if member does not exist, the user presses "New Member", the new member form opens. They fill in all the data, post to the members table, On Form Close I want the new members data (Name and ID) to transfer across to the Booking form and populate the member field.
It would probably be easier just to close the Booking form if the member doesn´t exist, add a new member in the new members form, save data to the members table, close the form and open a fresh instance of the Booking form.
If there is a smoother way I would be interested to find out.
Thanks
It would probably be easier just to close the Booking form if the member doesn´t exist, add a new member in the new members form, save data to the members table, close the form and open a fresh instance of the Booking form.
If there is a smoother way I would be interested to find out.
Thanks