B
Brian Fielding
The data base consists of scanners and scanner parts. We carry out
servicing on scanners and raise a service report (numbered) which records
work done and parts used (these are detrermined from the scanner type).
When a service report is input the scanner type is entered on the main form
and a subform is used to record the parts used. The user on entering the
subform is given a list of parts based on the scanner type and he selects
the parts used and adds quantities. This is done using the "after update"
event on the subform. This input of data appears to work OK.
Now problem is: if you move through the service forms the service parts are
displayed correctly but if you enter a subform to correct the information
held the part list shown is dependent on the first scanner type displayed
and not for the scanner type held on the main form.
I'm missing something obvious - on entering the subform the scanner type
needs to be updated (from the main form) before showing the list of scanner
parts.
How is this done ?
servicing on scanners and raise a service report (numbered) which records
work done and parts used (these are detrermined from the scanner type).
When a service report is input the scanner type is entered on the main form
and a subform is used to record the parts used. The user on entering the
subform is given a list of parts based on the scanner type and he selects
the parts used and adds quantities. This is done using the "after update"
event on the subform. This input of data appears to work OK.
Now problem is: if you move through the service forms the service parts are
displayed correctly but if you enter a subform to correct the information
held the part list shown is dependent on the first scanner type displayed
and not for the scanner type held on the main form.
I'm missing something obvious - on entering the subform the scanner type
needs to be updated (from the main form) before showing the list of scanner
parts.
How is this done ?