Option Button

Dec 7, 2006

I have a table that has 300+ peoples names on it. Each of these people has a region they belong to 1,2,3,or 4. I also have a form that has 3 combo boxes that are linked to this one table. This information is sensitive and can change by importing new data as well. Is there a way that I can add 4 option buttons, depending on what the user clicks on Opt1, 2, 3, or 4... that is what populates the combo boxs? This seems rather simple, but I can't figure it out.

View Replies


Option Button ??????

Jun 6, 2005

Lets say that I have a large list of locations in a listbox. What I want to do is to be able to have an option button that I can press in that will sort these locations. Like 3 or 4 different buttons, lets say like retail, finance, ect. Anyone know what kind of code I might have to use to make these sort on clicking the option button?

View 4 Replies View Related

Option Button - N/a

Mar 23, 2006

I'm working on a survey database, I'm having the users select the opton button to rate (1 - 10). Then as an after thought, I thought I would add a button that says N/A or doesn't apply. Course option buttons store numbers.

ANy idea's on how to accomplish this? What ever value gets stored I wouldn't include it in the results.

View 1 Replies View Related

The Option Button

May 30, 2006

Hi peeps,

I am encountering a few problems when I'm using the options button on a form.

Is there a way for the options button to display a different value instead of a -1 when the data is transfered to a linked table? i.e Good or Poor or Fair?

Also can a number of option buttons have the same control souce? at the mintue I have three buttons pointing at one control souce and when I select one of the buttons they all get selected.

Any help will be much appreciated.

View 14 Replies View Related

Value Of Option Button

Jan 24, 2006


how do I reference the value of an option button in an option group?

i tried this:
Code:If [exact] = -1 Then where = where & " AND [SerialNumber] = " & Me![serialno] ElseIf [exact] = 0 Then where = where & " AND [SerialNumber] = " & Me![serialno] Else where = where & " AND [SerialNumber] Like '*" & Me![serialno] & "*'" End If

attached is an image of the form.


View 1 Replies View Related

Option Button Unclick

Feb 2, 2006


Does anyone know how to unclick an option button on a form after a selection has been made?

One option is to go to the form and delete it there. But I am looking for a more effective way.


View 3 Replies View Related

Grey Option Button

May 23, 2006


I have a group of option buttons. A user can select more than one. However, currently all of the option buttons have a grey spot in them except for the first one which is blank. I want all of the option buttons to be blank.

Any thoughts?


View 2 Replies View Related

Calculation Using The Option Button

Jun 14, 2006

Hi there guys,

I have set up a form that is going to be used as a survey.

I have 19 questions that need to be answered and have set up an option group for each question containing 5 option buttons in each.

Is there away to calculate a total score?

for example if all questions were answered using opt5 then the total in the textbox would appear '95'

Thanks for all your help!

View 7 Replies View Related

Option Button Description Table

Nov 13, 2007

Option Button Description table

I would like to create a table containing description value of my option button group.

This is my description table:
1Lenke 1
2Lenke 2
3Lenke 3
4Lenke 4
5Lenke 5
6Lenke 6

And this is my table containing selected option from the form:

How can I associate description with the selected options?

Many thanks,


View 1 Replies View Related

Option Button Linked With Combo Box

Jun 28, 2006

Morning folks,

Todays problem is as follows!...

Is there away to set the values in a combo box depending on what option button you have selected.

What I would like is to select an option button in an option group then that would trigger certain vaules in a combo box. And if I selected another option button it would change the values in the same combo box?

So if I selected optWhite, the values in cboEthnic = British AND Irish AND Other

If I select optMixed, the values in cboEthnic = White and Black Asian AND White and Black Caribbean etc...

Hope this makes sense.

View 1 Replies View Related

Locking A Record Via An Option Button

Oct 11, 2004

On my form is an option button called "optClosed". When the option button is selected, I want to lock the current record so that data cannot be changed. Is this possible?

View 2 Replies View Related

Forms :: Option Button To Allow Yes / On But Disallow No / Off

May 7, 2015

I have a form that is linked to a table. The form show an option box that is by default set to off. This option button links to a yes/no field in the table.

I want to allow a user to change the state of the option box from off (no/false) to on (yes/true), but once it is on, it should not allow the user to switch it off.

View 3 Replies View Related

Forms :: Option Button String Value

Aug 3, 2015

My frame name is "Frame1" with Option buttons "Circle" and "Square"; My code line : Name = me.Frame1.however "Name" get a value of 1 or 2 depending on the selection.how I can get a return of the String Values instead of the Numeric values.

View 3 Replies View Related

Access Check Box And Option Button

Apr 25, 2013

I'm new to access. I have created table with following fields.

ID No, Name, Address, Gender, Favorite Food

I want to create form to insert data into tables. I have used option buttons for Gender and Check boxes for Favorite Food. But data didn't insert to the table specially option button and check boxes data didn't insert but other data successfully inserted into the table.


View 2 Replies View Related

How To Use Option Button To Store Value Into Table

Dec 9, 2013

I want to make option button in access to allow user choose status like: Single, Married and Widower


When user choose the value must save into table. How to do this?

View 4 Replies View Related

Configure Option Button To Output To Memo Box

Sep 8, 2005

Alright, I'm running out of options!! I have several pieces of equipment that use text file configuration data. What I want to do is create an option button for each piece of equipment so that when I click that option button, its output ties directly to a memo box.

What I want to be able to do is have 7 different option buttons and each time I click a different option button I can paste text file config data for each piece of equipment into the same memo box and save it. That way, when I query a particular site ID and look up configuration data for any one of those pieces of equipment, I will be able to view the saved config files in the same memo box just by selecting a particular option button.

Is this possible? I've tried subforms, tabs (although I can't seem to be able to use tabs within tabs), option groups, etc. Any suggestions or help would be most certainly appreciated! :p

View 1 Replies View Related

Option Group: How To Store Selected Button?

Aug 25, 2005


On my form I have an option group with 4 radio buttons. Depending on the button selected certain fields become visible. This works all fine. Problem is though that I don't know how to store the selected value. At the moment, every time you open the form you have to select the same button to see the info stored in the fields that become visible. I guess that I'll have to somehow store the value for the selected buttons in the table. But How? Do I refer to the frame and store the value corresponding to the number of button (1, 2, 3 or 4) or do I store the balue for each button seperately?
I've played with it for too long now and cannot find the golden tip. Please advice.



View 5 Replies View Related

Having An Option Button Select A Different Subform To Come Up In The Same Location

Aug 17, 2004

Asked this one yesterday but I think I must be doing somthing wrong. I have a main form named "Techdata" on this form I have an option group with 2 option buttons. I would like when selecting the first option button for the subform "effectivity" to show up on the main form. When the second button is selected I would like the subform "effectivity single" to show up in the same place where "effectivity" was(would like effectivity to be invisable then).
Can anyone walk me through this from whoa to go as Im havn a lil bitta trouble

Thanks for your time everyone

View 3 Replies View Related

Forms :: Option Group With Command Button

May 31, 2015

I'm using option group with value 1 and value 2 with a command button to open two different forms. This is the code:

Private Sub Command9_Click()
Dim strForm As String
Select Case Me.Cornice0
Case Is = 1

[Code] ....

I would like to close form's option group once clicked the command button after the opening of the requested value form. I tried Docmd.close but all I get is the option group no more working.

View 4 Replies View Related

Option Button - Use Text Instead Of Numeric Value In My Query/report

Apr 26, 2007

I am not sure what cateogory to choose for this question but I would greatly appreciate your help.

I have 5 buttons in my option group:
1. very often
2. often
3. occasionally
4. rarely
5. never

I have to produce a report using description of each button in my report, not numeric value. I heard something about global variable but I am not sure how to do it.

Many thanks,

View 1 Replies View Related

Modules & VBA :: Disabling Option Group If A Button Is Pressed

Jun 16, 2014

I have an option group with 2 buttons in it, yes and no. It is set to default to No, but if someone hits Yes I want it to enable or turn on the next option group. Would just simply changing visible status disable it? Because I have a series of codes set up based on the second option group which read as:

Private Sub NumberOfAdditionalSites_Option1_GotFocus()
Me.AdditionalSitesLabel1.Visible = True
Me.AdditionalSitesText1.Visible = True
End Sub

[Code] .....

I do not want these to be visible if the initial option group is still set to no.

View 4 Replies View Related

Forms :: Option Button Link To Invisible Subform?

May 8, 2014

I have two option buttons, 1_optn and 2_optn. I have two subforms, 1_frm and 2_frm.

When clicking the little round dot (the option button) for 1_optn, I want the subform 1_frm to become visible. Likewise, when clicking 2_optn, I want the subform 2_frm to become visible. In the properties panel, both forms visibility is set to No.

I have tried creating a Macro and the best I've gotten is using the OpenForm function but that opens up the forms in a new window. I'd set the Macro to the OnClick event for a combo box (as I couldn't get the option button to work) so when "1" is clicked, the form would pop up. But they have to be in the same form. No pop ups. It also has to be an option button, not a combo box or list box.It also has to be a Macro. No Event Procedure coding unfortunately.

View 1 Replies View Related

Modules & VBA :: Option Button To Filter Query On Form

May 14, 2014

how i would filter a form using an option button. E.g i want to be able to click an option button that is called Filter user and it will filter the query based on who is logged in? and a Filter all option that will clear the filter and show all records?

View 3 Replies View Related

Forms :: Option Button Traffic Light System

Aug 1, 2013

I have set up a group of 3 buttons to select between on my form which works fine.

However I want this to be a bit more visual than it is so Id like to introduce a traffic light system which lights up RED ORANGE or GREEN depending on which one has been checked.

I am not too sure how I would go about achieving this, im not sure if you can import images and hide them or show them depending on the selection or if it requires something further.

View 4 Replies View Related

Use An Option Button On A Form To Select An Alternate Input Mask

Sep 25, 2006

I can create a customized Input Mask, however there are two possible structures that the data may take. I think that this should be doable by the use of two fields, if it can be done with one field it would be preferable for searching options. If I have to use two fields there would only be one or the other used for each record so I would prefer to have the unused field inhibited. Either way the code work is beyond my present ability, any assistance would be appreciated.

View 1 Replies View Related

Forms :: Lock / Unlock Textboxes Based On Option Button?

May 11, 2014

I have a form with 2 option buttons on it one with year 12 on it and one with year 13. I have a simple form with drop down menus and text boxes allocated for year 12s and 13s. I want all of the year 13 text boxes and drop down lists to be locked if year 12 is selected and I want all of the year 12 text boxes and drop down lists to be locked if year 13 is selected. I do not want to over complicate the form by hiding parts of it or having a new form open depending on the option button selected.

View 9 Replies View Related

Copyrights 2005-15 www.BigResource.com, All rights reserved