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
 
Back
Top