View Single Post
  #1  
Old June 25th, 2004, 06:25 PM
Jason Gyetko
external usenet poster
 
Posts: n/a
Default "#" from combo box causing problem with query?

I've got a form with with a combo box on it. The combo box is being
populated with data that has a "#" sign in it.

Ex: TONSIL TRAY #02

I'm then running a query that uses the combo box value for its criteria.

Ex: Like [forms]![MyForm]![cboComboBox]

This works fine for values that don NOT have a "#" in them, but nothing is
returned for the values that do. Does anyone know how to get around this?
Thanks.