dynamictiger
Registered User.
- Local time
- Today, 03:32
- Joined
- Feb 3, 2002
- Messages
- 270
I am currently playing with a second run at a design I have working in a prototype and trying to think outside the square.
I have a subform which contains a combination of nested and synchronised subforms. As we move from record to record on the main form the subforms all refresh, and within the master subform we have two subforms that are changeable to show information pertaining to the appropriate record. So far so good.
To date to align the forms we are using a combo box in the header of the master form to locate a record.
I now want to search by a second combobox. The second combo searches by the value in the master subform. One way to do this is to use the source object.
However when I use source object the subform group reloads itself twice. This is obviously not efficent and will inevitably slow my code down.
Any suggestions?
I have a subform which contains a combination of nested and synchronised subforms. As we move from record to record on the main form the subforms all refresh, and within the master subform we have two subforms that are changeable to show information pertaining to the appropriate record. So far so good.
To date to align the forms we are using a combo box in the header of the master form to locate a record.
I now want to search by a second combobox. The second combo searches by the value in the master subform. One way to do this is to use the source object.
However when I use source object the subform group reloads itself twice. This is obviously not efficent and will inevitably slow my code down.
Any suggestions?
