Date search problem in combo box

G

Guest

Hi all

I am using text boxes to input the StartDate and EndDate. A combo box
displays the results. This works fine until I try to change the search dates.
The search results don't change in the combo box. The text boxes and the
combo are all unbound. I am using the "Between" code in the criteria of the
combo's query under StartDate. I will appreciate any help on this.
 
J

John W. Vinson

Hi all

I am using text boxes to input the StartDate and EndDate. A combo box
displays the results. This works fine until I try to change the search dates.
The search results don't change in the combo box. The text boxes and the
combo are all unbound. I am using the "Between" code in the criteria of the
combo's query under StartDate. I will appreciate any help on this.
Click to expand...

Requery the Combo Box in the AfterUpdate event of both textboxes.

John W. Vinson [MVP]
 

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

Add <ALL> to combo box 9
Re: Pass field value selected in Combo Box to SQL Query 1
Populate a text box based on a combo box 1
Combo box to fill text boxes.. 3
MsgBox Displays Twice 5
Access Microsoft access database(creating a search engine form) 0
Combo Boxes 4
Combo box synch question 2

Top