Option Group Question

[Abbosy]

Hi there Forum

In my Form

I have an "Option Group" which has 5 radio buttons or option buttons.

The option buttons are there for the customer to pick up number of years to buy extended warranty.
I have managed to work out how it works and adds to the existing "DateExtendedWarrantyTaken" with your help off course.

The thing that I need to click so the new date shows because I have put the results in a new controller which works as a holder only then when I click on the ExtendedWarranty it shows the new date.

I need to do it in a more professional way. To select the option and for it to show immediately on the ExtendedWarranty.

I'm sure this is possible

Best Regards
Abbosy

 

[pr2-eugin]

Try the AfterUpdate event of the Option Group Frame.

 

[Abbosy]

Great one Paul

Thanks very much. It did work perfectly well.



Regards
Abbosy

 

[pr2-eugin]

Most welcome. Good Luck !

 

[ccomputerinc]

I am trying to use an option group as well to open forms.

I have entered the code as described in the book, however when I run the code it says I haven't selected an option. See code below. Any help would be appreciated. Thanks

Private Sub OkButton_Click()
Select Case Me!WhereTo.Value
Case 1
DoCmd.OpenForm ("HoH Data Entry")
Case 2
DoCmd.OpenForm ("HoH Distribution")
Case 3
DoCmd.OpenForm ("HoH E Newsletter")
Case 4
DoCmd.Quit
Case Else
MsgBox ("You didn't select an option")
End Select
End Sub

 

[pr2-eugin]

I have entered the code as described in the book, however when I run the code it says I haven't selected an option. See code below. Any help would be appreciated. Thanks

So did you select an option? If yes, are you sure that you are referring tot the right controls?

 

[ccomputerinc]

I ran the program and made the selection, but it only runs the MsgBox saying "I have not made a selection". I got the code from a book (Dummies Access 2010) so not sure why it doesn't work. How would you recommend setting up code to open forms based on user selection? Any help you could provide would be greatly appreciated. Thanks

 

[pr2-eugin]

Could you upload a Stripped DB !

How to Upload a Stripped DB.

To create a Sample DB (to be uploaded for other users to examine); please follow the steps..

1. Create a backup of the file, before you proceed..
2. Delete all Forms/Queries/Reports that are not in Question (except the ones that are inter-related)
3. Delete auxiliary tables (that are hanging loose with no relationships).
4. If your table has 100,000 records, delete 99,990 records.
5. Replace the sensitive information like Telephone numbers/email with simple UPDATE queries.
6. Perform a 'Compact & Repair' it would have brought the Size down to measly KBs..
7. (If your Post count is less than 10 ZIP the file and) Upload it..

Finally, please include instructions of which Form/Query/Code we need to look at. The preferred Access version would be A2003-A2007 (.mdb files)