Use of a variable as a criteria in a Select command of a ComboBox

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I tried to use a control as a criteria of a Select command in a Combo Box but
the returned value d'ont atualizes after the second query. Therefore a tried
to use a variable as the criteria but the select command does'nt worked
properly.
Sorry if my English i'snt clera , but can somebody help me?
Thanks
Walter
 
Try:


Me.ComboBoxName.Rowsource = Me.ComboBoxName.Rowsource


in the AfterUpdate event of the TextBox that your SQL statement uses as
reference.


Hoping it may help,
Vanderghast, Access MVP
 
Back
Top