ListBox parameters problem

Status
Not open for further replies.

baddy

New member
Local time
Today, 00:42
Joined
Aug 15, 2005
Messages
8
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?
 
Status
Not open for further replies.

Users who are viewing this thread

Back
Top Bottom