freespiritcherishes
Technical User
Hi everyone...
In a table i have 6 hyperlink fields
ItemLinks 1 to 6.
On a form I created 6 combos. One for each ItemLink field.
Eg. CDItemLink1 has a hyperlink to a document on my hardisk.
CDItemLink1Cbo looks up all the records where a user has entered a hyperlink in this field.
But i don't want all 6 combos to show. I want 6 combo buttons numbered 1 to 6 each when clicked will make visible their respective combos so that the user can select from that combo.
But if i make the combo visible on the onclick event of each button, access won't let me make the combo itself invisible when it has lost the focus, so i can't hide the control for when another combo button is clicked and an alternative combo appears. As a result all combos will appear when the idea is to have all 6 sitting on top of each other where they only take up one line of space instead of 6 on my form.
Again, the word loop or case comes to mind, but as per usual, I have no idea. Ive tried everything!
Can anyone help?
In a table i have 6 hyperlink fields
ItemLinks 1 to 6.
On a form I created 6 combos. One for each ItemLink field.
Eg. CDItemLink1 has a hyperlink to a document on my hardisk.
CDItemLink1Cbo looks up all the records where a user has entered a hyperlink in this field.
But i don't want all 6 combos to show. I want 6 combo buttons numbered 1 to 6 each when clicked will make visible their respective combos so that the user can select from that combo.
But if i make the combo visible on the onclick event of each button, access won't let me make the combo itself invisible when it has lost the focus, so i can't hide the control for when another combo button is clicked and an alternative combo appears. As a result all combos will appear when the idea is to have all 6 sitting on top of each other where they only take up one line of space instead of 6 on my form.
Again, the word loop or case comes to mind, but as per usual, I have no idea. Ive tried everything!
Can anyone help?