List Box Multi Search

[TheViruz30]

See attached Database


I'm trying to create a list box as you can see in the list box section
is conected to the patients query

What i'm trying to do is is link the text box to the list box but dont know how to do it.

Also user can search by Account#,Last Name, First Name and Social security # all in one field any ideas.

 

[Oldsoftboss]

This sould do what you want.
Notice I have fixed up the table slightly. It is good practice to remove the spaces from field names as it becomes a nightmare once you get in to programming a bit more.

Dave

 

[TheViruz30]

Re: list Box

Thank you Very Much