Hi there.
I found this example somewhere (see attachment search multiple fields.zip) and thought it would be great for my DB.
I have a list box set up in my database's startup form that displays all of the open cases (child records that have a null value in the enddate field). I want to display fields such as "Unit" "FirstName" and "LastName" "Isolationtype" and so on, so that the user can easily identify which record they want to get into to close. The example doesnt show a parent child db setup, and I'm not sure how to reference it in row sources to get the relavant information in there. Any ideas?
-Z
I found this example somewhere (see attachment search multiple fields.zip) and thought it would be great for my DB.
I have a list box set up in my database's startup form that displays all of the open cases (child records that have a null value in the enddate field). I want to display fields such as "Unit" "FirstName" and "LastName" "Isolationtype" and so on, so that the user can easily identify which record they want to get into to close. The example doesnt show a parent child db setup, and I'm not sure how to reference it in row sources to get the relavant information in there. Any ideas?
-Z