D
Dan
I have an orders form with an order details subform. Allow Filters, Edits,
Deletions, Additions and Data Entry are all Yes.
I have a ListBox on the orders form to select the customer name, and when
the customer is chosen, I want to set the default value for one of the fields
in the order details subform. I do this in the ListBox's AfterUpdate event
and it's working fine.
I have two buttons on the orders form for going to the next and previous
records. They use the standard code:
DoCmd.GoToRecord , , acNext
DoCmd.GoToRecord , , acPrevious
These also are working fine. However, when the button click events are
executed, I want to detect the customer of the record that is going to be
displayed and also set the default value for the field on the subform. I
cannot find any of the ListBox's events that is triggered by the
DoCmd.GoToRecord, even though the ListBox is getting updated correctly when
it goes to the next or previous records.
What is going on here? How do I get what I want?
Thanks!
Deletions, Additions and Data Entry are all Yes.
I have a ListBox on the orders form to select the customer name, and when
the customer is chosen, I want to set the default value for one of the fields
in the order details subform. I do this in the ListBox's AfterUpdate event
and it's working fine.
I have two buttons on the orders form for going to the next and previous
records. They use the standard code:
DoCmd.GoToRecord , , acNext
DoCmd.GoToRecord , , acPrevious
These also are working fine. However, when the button click events are
executed, I want to detect the customer of the record that is going to be
displayed and also set the default value for the field on the subform. I
cannot find any of the ListBox's events that is triggered by the
DoCmd.GoToRecord, even though the ListBox is getting updated correctly when
it goes to the next or previous records.
What is going on here? How do I get what I want?
Thanks!