Requery Problem

[FoxStudent]

I have written an SQL query to filter out the street names in a particular area. I have done this kind of thing before but this time it does not work. I have placed a button on tyhe form to run the query. So after I select an area i run it and it returns the correct results. I set the row source of the address combo to the query and have requeried the query in the after update event of the area combo box. Has anyone any suggestions? Thank u alot everyone that has helped me past and present.

 

[andrewvanbeck]

Access acts weird when changing SQL data, sometimes it does'nt realise you've changed something, why not requery your address combo after you change its SQL properties, not after an update.

Andrew.