Part list not updated on change of type.


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 ?
 
Ad

Advertisements

J

John W. Vinson

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 ?

What are the Master Link Field and Child Link Field properties of the subform?
 
Ad

Advertisements

B

Brian Fielding

John W. Vinson said:
What are the Master Link Field and Child Link Field properties of the
subform?


The JobNo (Service Report number) are the Master Link Field and Child Link
Field


Thanks for your help
Brian
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top