ListBox parameters problem

[baddy]

I have a form with one listbox, two combo boxes and two text boxes that provide parameters for the query that feeds the listbox. The selection of parameters trough comboboxes works perfectly but the query does not pick up parameters(datefrom/dateto) form text boxes. When I remove references to combos, date parameters work just fine, but the dates are not selected when there is reference to combos. The code behind combos is as follows:

Private Sub CboStaff_AfterUpdate()
Dim vSearchString As String

vSearchString = Me.CboStaff.Text
Me.txtSearch2.Value = vSearchString
Me.MyList.Requery

What am I doing wrong?

 

[yellow]

Why don't you post this a few more times? Perhaps you could try posting a few in Tables and a couple in Macros.

 

[baddy]

Sorry, I'm on dial-up today and it's so slow that I had to repost beliving that the massage hadn't got trough.

 

[ColinEssex]

Delete the others then

 

[JVermast]

Colin my hometown is Essex (Canada)

 

[ColinEssex]

Colin my hometown is Essex (Canada)

In the UK, its a county (a province? in Canada?)

Col

 

[JVermast]

Yeah I know some guys from Essex, UK. Niall Chadwick for one. Maybe you know him!

Essex is a town in the province of Ontario.