C
C Tate
I have created a small reservations database. The main booking form has been
created from a query based on several tables (eg, customer, booking,
excursion, passengers).
I now want to create another form (probably based on another query -
bookings and payments) for payments. I want to put a command button on the
main booking form linking to this form.
My problem is this. When I open the new payment form from the booking form,
how can I ensure that I am at the same bookingID? In other words, I want to
ensure that the payment I am entering is for the relevant booking!
I can't see an obvious way to do this. I did try but when I open my payment
form I think I am taken to the first bookingID.
Hope this all makes sense. Thanks in advance.
created from a query based on several tables (eg, customer, booking,
excursion, passengers).
I now want to create another form (probably based on another query -
bookings and payments) for payments. I want to put a command button on the
main booking form linking to this form.
My problem is this. When I open the new payment form from the booking form,
how can I ensure that I am at the same bookingID? In other words, I want to
ensure that the payment I am entering is for the relevant booking!
I can't see an obvious way to do this. I did try but when I open my payment
form I think I am taken to the first bookingID.
Hope this all makes sense. Thanks in advance.