Using After Update to 'feed' another After Update

[goldenvision]

This mail will probably make more sense if you download the attachment.

(Ignore the errors on the first form, these have been removed to minimise size)

After updating the Search By Postcode combo box the Postcode District and Territory ID fields are updated with the related information.

I am also trying to display all of the other related postcodes in the subform on the right.

i.e. CB10 relates to Basildon. I want the form on the right to display every other postcode that also relates to Basildon.

I have drawn a blank so far, any help would be a godsend.

Thanks in advance

 

[___]

Base the subform on the following query...


SELECT [Concession Territories].[Postcode District], [Concession Territories].[Territory ID]
FROM [Concession Territories]
WHERE ((([Concession Territories].[Territory ID]) Like [forms]![Main Form]![Territory Postcodes Form]![Territory ID]));


HTH

 

[goldenvision]

Base the subform on the following query...


SELECT [Concession Territories].[Postcode District], [Concession Territories].[Territory ID]
FROM [Concession Territories]
WHERE ((([Concession Territories].[Territory ID]) Like [forms]![Main Form]![Territory Postcodes Form]![Territory ID]));


HTH

Thanks very much that did the job.

Is it possible to use the OnChange function on a combo box as I need to add the Requery command when the combo box changes to update the postcode list?

 

[___]

Use the AfterUpdate event and a list box

HTH