Option Button Help (1 Viewer)

[Gr3g0ry]

i have an option button, which onClick will enable some textfields. is it possible to disable the previously enabled items when the option button is clicked again(unchecked) ?? and if so, how do i do this ? please and thanks

 

[theDBguy]

Hi. Can you post the code for the option group? Does it have an Else part?

 

[MajP]

May want to look here for some ideas

Set a group of controls as visible/hidden, enabled/disabled or locked/unlocked

The attached utility demonstrates a way of setting the state of a group of controls at the same time using the controls' Tag property. The properties that can be controlled are: .Visible , .Enabled, .Locked However, some control types do not allow all of the properties. For example labels...

www.access-programmers.co.uk

 

[Gr3g0ry]

Hi. Can you post the code for the option group? Does it have an Else part?

option group ? whats that ?? im a noob... this is the first time im attempting to use an option button

Private Sub orgCheck_Click()
Me.orgname.Enabled = True
Me.orgaddress.Enabled = True
Me.orgtype.Enabled = True
Me.orgcontact.Enabled = True

End Sub


this what i have so far

 

[Gr3g0ry]

May want to look here for some ideas

Set a group of controls as visible/hidden, enabled/disabled or locked/unlocked

The attached utility demonstrates a way of setting the state of a group of controls at the same time using the controls' Tag property. The properties that can be controlled are: .Visible , .Enabled, .Locked However, some control types do not allow all of the properties. For example labels...

www.access-programmers.co.uk

lol ... thanks ... its a bit more technical than my experience allows me to understand. i will return to this after i learn about option groups. thanks

 

[MajP]

google access option group. You can get a lot of videos showing how to use it.

 

[theDBguy]

option group ? whats that ?? im a noob... this is the first time im attempting to use an option button

Private Sub orgCheck_Click()
Me.orgname.Enabled = True
Me.orgaddress.Enabled = True
Me.orgtype.Enabled = True
Me.orgcontact.Enabled = True

End Sub


this what i have so far

Hi. Can you post a screenshot of your form? Sounds like you may have a toggle button instead of an option group.

 

[Gr3g0ry]

Hi. Can you post a screenshot of your form? Sounds like you may have a toggle button instead of an option group.

this is the option button im talking about

 

[MajP]

Try the image with the square and XYZ

 

[theDBguy]

View attachment 81580
this is the option button im talking about

View attachment 81581

Thanks! Try changing your code to this:

Private Sub orgCheck_Click()
Me.orgname.Enabled = Me.orgCheck
Me.orgaddress.Enabled = Me.orgCheck
Me.orgtype.Enabled = Me.orgCheck
Me.orgcontact.Enabled = Me.orgCheck

End Sub

If that doesn't work, try moving your code to the AfterUpdate event.

 

[Gr3g0ry]

Thanks! Try changing your code to this:

Private Sub orgCheck_Click()
Me.orgname.Enabled = Me.orgCheck
Me.orgaddress.Enabled = Me.orgCheck
Me.orgtype.Enabled = Me.orgCheck
Me.orgcontact.Enabled = Me.orgCheck

End Sub

If that doesn't work, try moving your code to the AfterUpdate event.

works like a charm ....

 

[theDBguy]

works like a charm ....

Glad to hear you got it to work. @MajP and I were happy to assist. Good luck with your project.

 

[M. Hamzah]

Hello,
Would I be able to use the option group for multiple sites on a data entry form where I can select either one ore (more sites)? As a result of the buttons I select I would like the site field in the "Available_At" field in the table updated accordingly? I found a lot of help on option groups but I couldn't find one in which I could select more than one button. Thanks

 

[theDBguy]

Hello,
Would I be able to use the option group for multiple sites on a data entry form where I can select either one ore (more sites)? As a result of the buttons I select I would like the site field in the "Available_At" field in the table updated accordingly? I found a lot of help on option groups but I couldn't find one in which I could select more than one button. Thanks

Hi. Try using the Wizard to see. As far as I can remember, an option group only allows for one choice selection at a time. If you want multiple selections, you might just have to use independent checkboxes instead of an option group.

 

[Pat Hartman]

the Option Group is bound to a single column so the answer to "can it support multiple selections?" is NO.

If you want to support multiple selections, you really need a separate table and you would use a subform to hold the selected items.

 

[Sazed]

Hello, the table has a filed namely 'Serial_Number' while another field name is 'Stock' (Checkbox). The Serial_Numbers are of the Instruments that we issue to users. When we issue the Serial_Number (instrument) to a user we press the Stock checkbox means the instrument with that particular serial number is currently with that user. The next time when that user returns to us then we issue it to the warehouse and then press the Stock checkbox, means the instrument is now with the currently receiving warehouse.

Now, I want the previously checked Stock checkbox field for the same serial number get unchecked automatically as I press the Stock checkbox for the latest issue record of the same serial number.

Appreciate your help!

 

[theDBguy]

Hello, the table has a filed namely 'Serial_Number' while another field name is 'Stock' (Checkbox). The Serial_Numbers are of the Instruments that we issue to users. When we issue the Serial_Number (instrument) to a user we press the Stock checkbox means the instrument with that particular serial number is currently with that user. The next time when that user returns to us then we issue it to the warehouse and then press the Stock checkbox, means the instrument is now with the currently receiving warehouse.

Now, I want the previously checked Stock checkbox field for the same serial number get unchecked automatically as I press the Stock checkbox for the latest issue record of the same serial number.

Appreciate your help!

Hi. May I suggest you start a new thread of your own and post a sample copy of your db with test data.

 

[Gasman]

@theDBguy,
The o/p has done, 4 times. Now called Option/Checkbox Issue or something like that.

 

[theDBguy]

@theDBguy,
The o/p has done, 4 times. Now called Option/Checkbox Issue or something like that.

I see. Thanks!