My Search Form seems to hang up my search request.
I am creating a simple database that organizes a small number(maybe up to 500) of standardized patients with their medical history.
I want to create a search form that allows a user to select as many search variables as they wish and have that linked to a query. This task is normally pretty simple, but I am having difficulties this time.
When I use the form, sometimes it just hangs up for no reason and provides no search results. I know my criteria is correct, because if I use the query without the form, I fill in the parameters and get the results I want. But when I use the form, it will sometimes send back no results. I say “sometimes” because it doesn’t seem to have a pattern of the when’s and whys it wont work.
I will need to search for more then 40 variables when looking up a patient so the form will make it easier then answering questions on the parameter window that opens up when I do a query.
Anyway, Database is attached. All names and contact info has been removed to ensure privacy is not breached.
Any help would be appreciated.
Sample for Forum.zip
PS, I know I should use separate tables for duplicate data, but due to importing issues I need to keep this database flat with no relationships.