An update.....
The on current option - I couldn't seem to get it to work dynamically (ie update when flicking to the next form...) but putting the Select Case in place instead of the If staements still seemed to work a treat.
I'll probably leave it as it is now, as this is in escence what I was after (the ability for the dynamic update fits nicely in the obsesive/compulsive streak that I tend to get every now and then.... :-)...
TimC
Last Activity: Jul 17 '06, 12:18 PM
Joined: Jul 6 '06
Location: NSW .au
-
Thanks Comteck,
I will give it a burl over the next day or so, and give you feedback on how it goes...
Just FYI - yes the checkbox is bound to in an underlying table (same as the combo boxes)....
Thanks for the tip for use of OnCurrent - It is these sort of things that you miss as a self taught Access user (and I really need to take a write VBA code course, as I tend to get lost in the heavy stuff from time to time. A...Leave a comment:
-
Mucking about with the code as below, it is nearly working how I thought I wanted it to... but it still requires a previuosly checked (true) checkbox to be unchecked and then checked to force the update and show the Comboboxes again
Private Sub EquipmentProble ms_Check_Before Update(Cancel As Integer)
If Me.EquipmentPro blems_Check = True Then
Me.Equip_Probs_ 1.Visible = True
Me.Equip_Probs_ 2.Visible...Leave a comment:
-
Thanks for the reply and information Comteck - much appreciated - and it is working as you thought it would.
It probably will work in it's current format - I'll have to test it on the labrats at work over the following couple of days.. :-) But if I may pursue this a bit further
Is it possible to expand the underlying code to keep the ComboBoxes visible once a true value is recorded on the Checkbox? (to allow these...Leave a comment:
-
Show/Hide ComboBoxe/s base on a tick box answer
Hello all,
A question from someone who dabbles in Access.
Is it possible to hide or ghost out a combo box (or set of them) on a Form, and only have them appear as a usable option if a tick box option that is also on the form is ticked or marked as true ??....
I am asking this as I want to prevent people entering the data into these combo boxes unless they have selected this tick box. I have a few queries that...
No activity results to display
Leave a comment: