This form has details of beer orders, in this example Order ID 1725127, which has separate record pages for the three beers in the order. The one shown is for Aspall Cyder, for which 3 were required, each needing to be assigned to a separate cask.
The Book Out button for this 'Foreign' product on Page 2 of 3
- asks for the first Cask ID
- does several integrity checks
- updates the tables containing the product and order details
- opens a new form to show the changed data
- on closing this form, updates what's displayed on the Booking Out form
The first obstacle was that doing this caused the focus to jump to Page 1 on returning to the Booking Out form, same when repeating the process on Page 3. This was cured by changing Me.Requery to Me.Recordset.Requery at the end of the booking out code.
Now the list box AssignedForeign doesn't update (this shows all CaskIDs already assigned).
As above,
- CaskID 46673 is shown but needed change page or close/reopen form to make it appear
- CaskID 46906 has since been booked out but the list box still shows just 46673
- Casks Assigned correctly shows 2
I've tried adding Me.AssignedForeign.Recordset.Requery in different places but without effect. Suggestions please?!
Can provide the booking out code if it helps.
The Book Out button for this 'Foreign' product on Page 2 of 3
- asks for the first Cask ID
- does several integrity checks
- updates the tables containing the product and order details
- opens a new form to show the changed data
- on closing this form, updates what's displayed on the Booking Out form
The first obstacle was that doing this caused the focus to jump to Page 1 on returning to the Booking Out form, same when repeating the process on Page 3. This was cured by changing Me.Requery to Me.Recordset.Requery at the end of the booking out code.
Now the list box AssignedForeign doesn't update (this shows all CaskIDs already assigned).
As above,
- CaskID 46673 is shown but needed change page or close/reopen form to make it appear
- CaskID 46906 has since been booked out but the list box still shows just 46673
- Casks Assigned correctly shows 2
I've tried adding Me.AssignedForeign.Recordset.Requery in different places but without effect. Suggestions please?!
Can provide the booking out code if it helps.