Combo box problem

  • Thread starter Thread starter Podegecom
  • Start date Start date
P

Podegecom

My form asks for a Start date and End date which
generates a report on all contacts with Companys within
those dates. I cant get my combo box to work with the
form where I have the option to select one company or All
companies within those dates.
I think I need an event procedure - afterupdate? but have
no idea how to write this.
My combo box is called CompanyName

Any suggestions
 
If I understand correctly what your problem is:

Assuming the rowsource of your combo is a query or SQL statement utilising
the start date and end date from the form as criteria (if this is not the
case, then you need to do it)... use the after update event of both start
date and end date to run the same macro, which performs a Requery action on
the combo.

HTH,
Nikos
 

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

Data entry VBA 1
Data entry to table from a form 1
Combo Boxes 1
Data entry for a table from a form 2
Combo box help please 5
Updating combo box data 4
1 combo box changes per 2 other combo boxes 3
combo boxes 8

Back
Top