I have combo box that is based off a table of names. I need the user to be able to select the name and just those records pull up. I have a query with the info in it linked to that combo box, but when I select a name nothing comes up. The problem that I am running into is that the name field looks like this...
doe, john
and it seems like the combo box will not recognize the name because of the comma. Is there a way to get around this without changing my data to not having a comma?
Thanks for the help in advance...
jnp102
doe, john
and it seems like the combo box will not recognize the name because of the comma. Is there a way to get around this without changing my data to not having a comma?
Thanks for the help in advance...
jnp102