Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version


Notwithstanding information missing in the Base form provided, the problem was found (created dummy sample data for testing).

Your entire approach seems to be somewhat faulty. sqlMultiForm is attached to table person and the controls in that form are all pointing to blank fields. Even simple mouse clicks after any two selections is causing problems.

What you really have is a filtering situation which would eliminate much of the code you have created. Using a filter table, the selected item data is stored in the single record. When all selections are made, you can use the data in the record in a query to select the information desired. Don't really see any need for the check boxes, since you can accommate non selection by checking for null values in the query.

End result would be little if any coding.

For more on table filtering see this post -> Filter/Search with Forms (leveraging SubForms). It also includes many samples.