requerying two columns of the same query results.

[22strider]

Hello Friends

I am having hard time re-querying two fields of one query result.

I have a query that shows results with two columns "Postal Code Category" and "Postal Code Sub Category". "Postal Code Category" is first three letters of the postal code and "Postal Code Sub Category" is last three letters of the postal code.
In a new form I have created two combo boxes and trying to perform re-query function to do the following:
When I select a particular "Postal Code Category" in the first combo box, I should only see relevant "Postal Code Sub-Category" in the second combo box.

Thanks for your help
Rajesh

 

[SydneyGeek]

Hi Rajesh,

See if this helps. Basically you have a loop.
1. The second combo uses the bound column of the first combo as its criteria
2. The AfterUpdate event of the first combo has code to requery the second combo.

Denis

 

[22strider]

thanks; it worked. I was trying the same thing by using macro builder but for some reason it didn't work. Thanks for guiding me towards that page

 

[SydneyGeek]

You're welcome