combo box for filter

Z

zweet18

I have form with 2 combo boxes for filter and search button to do the search.
what i want is remove search button just only combo box when they click or
select cboFirmName and cboCountry it will auto Update the
txtCity,txtstreet,txtphone can anyone help i'm just new in access i'm just
studying by myself

cboFirmName:
cboCountry:


txtCity:
txtstreet:
txtPhone:

thanks,

appreciate a lot!!
 
M

Marshall Barton

zweet18 said:
I have form with 2 combo boxes for filter and search button to do the search.
what i want is remove search button just only combo box when they click or
select cboFirmName and cboCountry it will auto Update the
txtCity,txtstreet,txtphone can anyone help i'm just new in access i'm just
studying by myself

cboFirmName:
cboCountry:


txtCity:
txtstreet:
txtPhone:
Click to expand...


Move the code in the body of the search button's Click event
procedure to the dependent combo box's (cboFirmName?)
AfterUpdate event procedure.
 
Top