which operator

[Guest]

Hi All,

trying to pull out list of names from a table

need a operator which will show the names when the clinic name is entered.

e.g. Box asking Name of clinic --- American Hospital... on enter OK button
should show list of patients visited American Hospital..

Similary for other hospitals when entered should show its respective patients

Thanks

Gerald

 

[John Vinson]

Hi All,

trying to pull out list of names from a table

need a operator which will show the names when the clinic name is entered.

e.g. Box asking Name of clinic --- American Hospital... on enter OK button
should show list of patients visited American Hospital..

Similary for other hospitals when entered should show its respective patients

Thanks

Gerald

Without knowing the structure of your table, I'll have to guess
here... but I'd expect that if you create a Query based on your table,
containing the fields that you want to see and the clinic name, and
put

[Enter clinic name:]

on the Criteria line, you should get what you want.

If you've been misled into using Microsoft's "Lookup Wizard" then the
clinic name will not in fact be in your table; you'll need to join the
lookup table to the Query in order to search for the name.

John W. Vinson[MVP]