Synchronized combo boxes

[Guest]

I followed the knowledge base instructions and have one problem the bound
column is text and I need to get the quotation marks around the Me.Field. In
other words, i need to get a result of WHERE CategoryID = "02" and not
WHERE CategoryID = 02

What do I add to the code to get quotation marks displayed?

Thanks!!

 

[Svetlana]

"CategoryID=""" & Me.Field & """"

 

[Guest]

Thanks, Svetlana! That worked, but can I prevent the first item in the
dropdown list from automatically appearing in the combo box? I'd the box to
remain empty and let the user select from the list.

Thanks.