combo box for filter

G

Guest

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to use txtboxes and Combo boxes in a form 3
Cascade combo box help! 8
Combo Box 2
Combo Box for Data Entry 1
SQL problem 1
Filtering and Removing Filter based on a combo box 4
Dynamically update a combo box list 2
Filter combo box based on another unrelated combo box 1

Top