Using a Listbox to populate a form

[Siggy19]

On my main form I have a multi-select list box of patient names. When the user presses the 'View Patients' button, I want a form to pop up with the information for the patients selected in that list box shown one at a time with the normal navigation buttons available.

Currently, the View Patients form simply lists all of the patients in the database, but this is not what I want.

Any ideas ?

 

[ProgramError]

siggy

could it be that you are viewing the results in dataview and not form view?

why not try creating a subform with the record source being the result of the dropdown list.



Program Error
Programmers do it one finger at a time!

 

[ProgramError]

you may find ths useful too

http://www.datapigtechnologies.com/flashfiles/buildcustomfilter.html

Program Error
Programmers do it one finger at a time!