dapfeifer
Bringing Maverick Mojo
- Local time
- Today, 05:30
- Joined
- Jun 17, 2008
- Messages
- 68
Hey all,
My form contains 4 combo boxes and a subform. When first opened, all the combo boxes are blank and the first one is the only one selectable. Once a value is put into that, the subform's query is to update to match the input from the first combo box and the second combo box becomes selectable. Once a value is selected from that combo box, the subform is updated to match the values of the first and second combo box and the third combo box becomes selectable. The process continues this way until the fourth combo box has a value, at which time the subform updates to match all combo box selection.
My question is how do I write a query that can do this? Do I need multiple queries that are called on based on what has been filled in? If so, how do I update the subform's source in order for that to work? The closest thing I've had to a working operation would load the form, but once I selected a value Access locked up completely and I have to force-close access.
The combo boxes would go in this order:
Payor Code->Client Name->Sender/Receiver->File Type
Any feedback would be appreciated, and if you need clarification on what I'm trying to accomplish I'll try and clear things up a bit.
My form contains 4 combo boxes and a subform. When first opened, all the combo boxes are blank and the first one is the only one selectable. Once a value is put into that, the subform's query is to update to match the input from the first combo box and the second combo box becomes selectable. Once a value is selected from that combo box, the subform is updated to match the values of the first and second combo box and the third combo box becomes selectable. The process continues this way until the fourth combo box has a value, at which time the subform updates to match all combo box selection.
My question is how do I write a query that can do this? Do I need multiple queries that are called on based on what has been filled in? If so, how do I update the subform's source in order for that to work? The closest thing I've had to a working operation would load the form, but once I selected a value Access locked up completely and I have to force-close access.
The combo boxes would go in this order:
Payor Code->Client Name->Sender/Receiver->File Type
Any feedback would be appreciated, and if you need clarification on what I'm trying to accomplish I'll try and clear things up a bit.
