M
Mike J
I have a main (customers) and subform (transactions) that is linked to the
main form. I want to open a new record in the subform each time a new main
form (customer) is opened. When I use the VBA DoCmd to go to new record on
Open event for the subform, it only works on the first opening to the forms,
not the next customer that is selected.
I then used same command On Current for the subform, it works for each
customer selected, but does not allow me to see previous records.
How can I open to a new record in the subform for each customer selected in
the main form and still be able to review previous records.
Mike
main form. I want to open a new record in the subform each time a new main
form (customer) is opened. When I use the VBA DoCmd to go to new record on
Open event for the subform, it only works on the first opening to the forms,
not the next customer that is selected.
I then used same command On Current for the subform, it works for each
customer selected, but does not allow me to see previous records.
How can I open to a new record in the subform for each customer selected in
the main form and still be able to review previous records.
Mike