Back to the code donated by JimmyTheGeek. I ran into some problems with my report. My user has two fields they can select from. Selection involves the use of check boxes. One field gives them 2 choices and the other field gives them 4 choices. For example:
Select Fruit:
Apple
Oranges
Select Fruit Type:
With seeds
seedless
Large
Small
What I did was cretae a table based on the fruit selection then a second table based on the fruit type selection (quereid off the fruit selection table). Once the selections are made the user can then select the individual fruit he wants to view from a second form based on the last table created. The only problem is that I have many people using the same dataabse and the table gets locked so only one person can use the table at one time. Is there any easy way out of this? I tried querying the form based directly on the values selected i.e.) forms!frm_GetFruit!txtFruit. However, I can only query for one fruit, not multiple.
This is making me wacko! Any help is appreciated.
Select Fruit:
Apple
Oranges
Select Fruit Type:
With seeds
seedless
Large
Small
What I did was cretae a table based on the fruit selection then a second table based on the fruit type selection (quereid off the fruit selection table). Once the selections are made the user can then select the individual fruit he wants to view from a second form based on the last table created. The only problem is that I have many people using the same dataabse and the table gets locked so only one person can use the table at one time. Is there any easy way out of this? I tried querying the form based directly on the values selected i.e.) forms!frm_GetFruit!txtFruit. However, I can only query for one fruit, not multiple.
This is making me wacko! Any help is appreciated.
