Subdatasheet current event

[Guest]

I have a data entry form that is used for recording products and product
batch numbers used for particular jobs. It comprises of a query (in a
subform) listing products with a subdatasheet listing product batch numbers
in a combo box. The values in the combo box are filtered so that only batch
numbers relating to the parent product are listed.

This all seems to work fine when adding entries. However when viewing
existing data, I have a problem. I need the batch subdatasheet combo to
requery when moving from one product record to another. Can this be done with
subdatasheets as there appears to be no equivalent to the 'current' event
like there is on forms?

 

[[MVP] S.Clark]

There isn't enough specific info to make a recommendation.

I get that there is a Form / Subform, and am assuming that the link master &
child fields are set. So, how does your combobox work above and beyond this
functionality?

 

[sjy]

I have a data entry form that is used for recording products and product
batch numbers used for particular jobs. It comprises of a query (in a
subform) listing products with a subdatasheet listing product batch numbers
in a combo box. The values in the combo box are filtered so that only batch
numbers relating to the parent product are listed.

This all seems to work fine when adding entries. However when viewing
existing data, I have a problem. I need the batch subdatasheet combo to
requery when moving from one product record to another. Can this be done with
subdatasheets as there appears to be no equivalent to the 'current' event
like there is on forms?

 

[takachan]

I have a data entry form that is used for recording products and product
batch numbers used for particular jobs. It comprises of a query (in a
subform) listing products with a subdatasheet listing product batch numbers
in a combo box. The values in the combo box are filtered so that only batch
numbers relating to the parent product are listed.

This all seems to work fine when adding entries. However when viewing
existing data, I have a problem. I need the batch subdatasheet combo to
requery when moving from one product record to another. Can this be done with
subdatasheets as there appears to be no equivalent to the 'current' event
like there is on forms?