S
sbehnke
Guest
Auto update info on Main Form from Subform
Been stuck for a long time, searched everwhere and tried a lot of code with no luck.
Would like to update information on a Form from a subform if conditions are met
eg Subform
[ProductName] widgets are ordered and [Quantity] 10 are required
I would like the [Quantity] 10 to appear on the main form.
Same OrderID
[ProductName] wombats are ordered and [Quantity] 5 are required
The subform is still required as different products may be delivered at different times.
It can be done by simply placing duplicate fields in the main form but this requires double entry.
Any help would be most appreciated and thanks heaps in advance.
Been stuck for a long time, searched everwhere and tried a lot of code with no luck.
Would like to update information on a Form from a subform if conditions are met
eg Subform
[ProductName] widgets are ordered and [Quantity] 10 are required
I would like the [Quantity] 10 to appear on the main form.
Same OrderID
[ProductName] wombats are ordered and [Quantity] 5 are required
The subform is still required as different products may be delivered at different times.
It can be done by simply placing duplicate fields in the main form but this requires double entry.
Any help would be most appreciated and thanks heaps in advance.