Many thanks for the help so far.
NeoPa
The Combo Box control details are as follows:
Control Source = Transactions.OrderStatusID
Row Source = SELECT [Order Status].ID, [Order Status].OrderStatus FROM [Order Status];
Format: Column Count = 2: Column Width = 0cm;2.5cm.
All
I have implemented the code suggested with one minor change as follows:
- Private Sub Report_Close()
-
Forms![Transactions]![Transaction Details Subform]![OrderStatusID] = 2
-
End Sub
This code updates one instance of the control on my form. There can be multiple instances however. As a simplified representation, the form looks like this...
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
-
Main Form
-
CustomerName : OrderNumber : Date : Comments
-
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
-
Sub Form
-
New: Qty : OrderCode : Description
-
New: Qty : OrderCode : Description
-
New: Qty : OrderCode : Description
-
...etc
-
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Where 'New' is the default value of the 'OrderStatusID' control I want to update
When I run the code (close the report) I get this...
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
-
Main Form
-
CustomerName : OrderNumber : Date : Comments
-
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
-
Sub Form
-
Confirmed : Qty : OrderCode : Description
-
New : Qty : OrderCode : Description
-
New : Qty : OrderCode : Description
-
...etc
-
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
A customer may request many items on any one order. - I want to confirm all of them at once.