combo boxes

K

Kathy G

I am attempting to limit the results in a combo box based on the information
entered in a textbox (which happens to be a persons SS#). I am having trouble
though. If I go into the query that the combo box is based on and type the
SS# without the (-) it produces nothing (which is what my combobox produces)
but if I go into the query and type the SS3 with the (-) it gives me the
results I want How do I make the results happen with my combobox?
 
R

Robbie G

HI Kathy,

It sounds like you stored the formatting of the SS#(you included the
dashes). Typically, you would setup a mask for data entry. The mask is just
for display purposes on the form and the SS# is stored without the dashes.
That way you can search for the SS# the way you want to. The best fix is to
strip the dashes out of the numbers you have stored with dashes. I would use
a VBA procedure to do this.

Rob G.
WizardWare, Inc.
 
Top