AlisonBrighton
New member
- Local time
- Today, 10:48
- Joined
- Feb 14, 2006
- Messages
- 3
Hi, I used to build access databases years ago. Agreed, after too many drinks the other night, to build one. Can't remember a thing!
So this is probably REALLY simple......so sorry!
I am trying to return a recordset to a subform based on user input in a form with number of boxes. The user needs to be able to input data in one, some or all of the boxes. if the user input criteria in 2 boxes for example, I need the option to refine the recordset returned by going back to the main form and choosing more criteria.
I have been basing the main form on a query, I have tried combo boxes, unbound boxes, everything!
I just can't get my head around where to start.
Thanks,
Ali
So this is probably REALLY simple......so sorry!
I am trying to return a recordset to a subform based on user input in a form with number of boxes. The user needs to be able to input data in one, some or all of the boxes. if the user input criteria in 2 boxes for example, I need the option to refine the recordset returned by going back to the main form and choosing more criteria.
I have been basing the main form on a query, I have tried combo boxes, unbound boxes, everything!
I just can't get my head around where to start.
Thanks,
Ali
