Option Of Two Sub Forms
Jun 20, 2005
Hello...
I am a newie to the forum... but like the system.
I was wondering if anyone can provide either some tips or sample of how to set up a form that give you the option of linking it to one of two forms.
Say the Main Form = General Plant Description
Sub Form One is for Info on Tractors
Sub Form Two is for Info on Trucks.
On the main form you select an option to show one of the subforms.
I have spent about 1.5 hrs trying to search the forum and so far havent found specific advice on this issue.
Thanks in advance.
Dave P
View Replies
ADVERTISEMENT
Jul 25, 2013
I stumbled upon the Option Group function just yesterday and, happy as a clam, I created a group with 2 options in radio button style. I assigned the values to a field called Registration_Type as the 2 options are "Confirmed Registrants" and "Prospective Attendees".
[Great. That part works well. When I look at the table, a 1 or a 2 is in that field so it's great to know how to control accidental ticking of radio buttons (previous 450 records or so didn't have this option group functionality so one might easily tick one of the buttons. So one part of controlling option group I know I can handle via the table itself for now.]
The challenge is how to ensure the user always ticks one or the other ... I went back to the main table and tested the 'required entry' option for the Registration_Type field but forcing an action like this is not ideal in my mind. The usual error message vagueness for the average user is no good and I don't want to limit the user so much.
Is there a way to simply have a popup come up warning that neither radio button was ticked? Perhaps something linked to the form - i.e., maybe "after update"?? I only learned about attaching code to before and after update on controls a couple of days ago, so not sure if this would be best approach.
Just something to let the user know that nothing has been ticked in the option group as that controls in which of 2 reports the data will show up in so any record not ticked might mean a registrant being left out, which would be rather disastrous <g>.
View 1 Replies
View Related
Mar 14, 2008
I’m really stuck on how to create: Check Boxes/Option button/Option Group in VBA.
Could someone help on either all of them or some of them please?
Thanks
Richard
View 2 Replies
View Related
Aug 18, 2006
I am using an Access database for a foreign language dictionary project.
One of the forms I use is populated by a query (qryLemmaTable) to retrieve information from tblLEMMA.
This form works precisely as I intend it to work, but there is a glitch on it that is driving me mad.
The form in question has an option group with 11 radio buttons that correspond to the parts of speech associated with each word in tblLEMMA.
When I click on the button optAdjective I apply a filter and the only records that are displayed are adjectives. (The same applies for Nouns, Verbs, Prepositions etc.)
Here is the glitch: even though the radio buttons apply the filter correctly, no “black spot” appears in the button. Other signals on the screen let me know what word type is selected, so I can accomplish what I want, but I want the “black spots” too!
Perhaps this will be a clue: For each radio button I use the following code in the GotFocus event.
Me.FilterOn = False
Me.Filter = "wordtype = 'A'" ‘(or N, etc)
Me.FilterOn = True
And this for the Lost Focus event
Me.FilterOn = False
Thanks for the help.
View 3 Replies
View Related
Aug 22, 2005
Hi
I've got an Option Group with 3 options; Yes, No and Future.
I also have a range of Check Boxes; 1 for every day of the week.
When one of the check boxes is selected I want the Option Group to change to Yes.
Currently, the Option Group defaults to Future and No will only be available by manually selecting it. This doesn't need to be changed.
Any help will be greatly appreciated!
Cheers
View 2 Replies
View Related
Apr 22, 2015
how to use option buttons? I've looked around, but I cant find any site, thread, etc, etc on how to fully use them. I have 3 option buttons, there "Retired" "Current" and "Not Stocking" I want them to be tied the the list box named "lstItems" that gets its info from a qryItems.
View 14 Replies
View Related
May 18, 2005
In the file MembershipV3A2K.zip that was posted at the link listed below...I found a form that had a feature I would like to use or create on my own. I'm not sure what to call this feature. But it looks as if the form has two option groups and a listing of all committee members. In one of the option groups you selected which report you wanted. The second group you selected your output method for the report. The form in the database posted is labeled as frmPreReport but I was not able to get this form to work, so I think various components are either disabled or removed???
I'm not familiar with visual basic and want to know if there is a way to create this feature without visual basic knowledge? If so, would anyone be able to point me in the right direction? If visual basic knowledge is required, what would be a good source for this information?
http://www.access-programmers.co.uk/forums/showthread.php?t=85876
View 4 Replies
View Related
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
Dec 24, 2014
how to give the option to open either forma or formb with a command button.
View 1 Replies
View Related
May 13, 2013
How to create a Web Form and include an option group (5 or 6 radio or check boxes)? I really need the page to layout all of the options (not in a drop down). This will allow users compare answers on the fly looking at the form.
View 2 Replies
View Related
Apr 1, 2015
I have an option group, with of course the button where you select and beside that is the label name.
On click this runs a query but my boss only wants it to run when you hit the actual select button and not the label name.
how can I disable the label name or unreferenced this to the option.
View 3 Replies
View Related
Jan 13, 2014
I have a text box for the user to enter the week number, I started thinking I wanted to have some more options here, can I be abit more clever with the options when designing a form to search by date?!
I want criteria like....
Specific Date
Between Dates
Current Week
Last 30 Days
View 8 Replies
View Related
Mar 28, 2013
I have tried creating a combo box in a form and as I have gone through the steps, the option to bind each choice that I created in my drop down box for the form is not an option, so how do I make each choice in my drop down box access the report I need?
View 1 Replies
View Related
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
Jul 27, 2015
How can it be that from Design view I can go to data sheet view, but from form view there is no option for data sheet view? On form property sheet "allow data sheet view" is "yes".
View 1 Replies
View Related
Jan 7, 2014
I currently have a form with two comboboxes. One contains a list of products that the user can select from the other contains a list of percentages (sales commission rates).
What I want achieve is that when the user selects a specific product then a specific commission rate is select.
However, after selecting the product the user should still have the possibility to select a different rate if that is what has been agreed with the client. Ie. deviate from the standard rate defined by choosing the product.
How can I link the two comboboxes so that the correct rate is selected? while still retaining the the possibility to select something different?
View 1 Replies
View Related
Apr 10, 2015
I am doing a worksheet for college and have been asked to create option groups on a form, but I cannot work out how to do this.
The screenshot shows what I have to do but I cannot get the option group wizard to open.
When creating my form based on the design in the screenshot I dragged the Rate field onto the design view sheet but it has only one option button connected to it, I need to add another one that will be connected to the same field and am not sure how to do it. I did try adding another option button from the control bar but I am not sure if is connected to the same field with the correct yes/no properties.
View 5 Replies
View Related
Nov 20, 2014
I have an option group with 4 options and I want them to display traffic light colours when an option is clicked. So if option 4 is clicked it displays red, if option 1 is clicked it displays green, however, once clicked the colours remain, and dont disappear when I click another option and they remain for all records.
Private Sub Frame742_AfterUpdate()
'Select Case Me![Frame742]
' Case 1
[Code].....
View 9 Replies
View Related
Mar 12, 2013
I have would like to have a option group requery a list box with 2 yes/no columns as the criteria.
First Option = No criteria
Second Option = Yes in first column only
Third Option = Yes in second column only
So far I've been able to get option 1 and 2 to work, but I've not been able to define the same value to the third option, some of the values in the 2 columns over lap so using a single option doesn't seem to be the right method.
View 1 Replies
View Related
Mar 31, 2014
In creating a form with checkboxes created using the "option group" control type,
I am trying to find a way to clear all the checkbox options in an option group after having checked an option. For instance, if the user checks one of the options but then decides they actually want to skip that question altogether and leave it blank - is there a way to clear all options, or reset the question?
View 6 Replies
View Related
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:
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
Jun 10, 2015
I have 2 Option buttons that I want to use to control a combo box. If I select Option1 then I want it to pull from one table for the drop-down choices. If I select Option2 I want it to pull from a different table. The Option buttons and combo box are all on the same form.
View 5 Replies
View Related
Mar 15, 2013
I have a main form named as FOTOFILM and a child form named as FOTOFILM_Subform ( Datasheet view, and datasource is a query builted on FotoFilm_table). they don't have relationship but the datasource for both is the same (FotoFilm_table).On the main form FOTOFILM, I have an option group named optChoose and 5 options within. Options are;
The last week,
The last month
The last 3 months
The last 6 months
the last 12 months
I would like to query / filter FOTOFILM_Subform by clicking any option.The field name ( to be filtered) IstekTrh (Date/Time-ShortDate)
View 1 Replies
View Related
Dec 9, 2014
I have a form with 5 options in a group. This works fine when I only have 1 filter applied to each button. I need to select the "Not Collected" button and have it filter out and show "Collected = No" and "Deleted = No". Here is my code..Case 3 is the one I'm currently working on. I can get the others once I figure out the first one.
Private Sub Frame799_Click()
Select Case Frame799
Case 1
[Code].....
View 6 Replies
View Related
Feb 2, 2014
I have a query that i need to run from a form. From form I need to pass criteria
1 for canada
2 for us
1 and 2 for us and Canada
The criteria needs to go into field Pricing Type. If user selects 1 then only Pricing Type 1 will display. If user selects 2 than only Pricing Type 2 should display. I user selects both , Pricing Type 1 and 2 should be listed.
Can this be achieved with option group?
View 2 Replies
View Related
Jan 29, 2014
I have an Option Group I created (simple Yes-No) in a form that links to a Yes-No field in a table. I have the default set for this field to "Yes" in the form. The option button works when the form is first opened. If I cange the option to "No", that works. Here's the tricky part that is giving me eye twitches...
If I change the option back to "Yes", the radial button doesn't reflect the change...but it does change the table data! Why do the radial buttons stop changing? Even when I close the form and open it again, the data in the table is no longer reflected with the buttons in the form.
I have 64-bit, Access 2010.
View 11 Replies
View Related
