Option Group Button Help - Microsoft Access / VBA

kufre

I need some help. I have a option group button that contain two
checkbox call Active and Inactive on my Filing form. This is what I
want, the Active box will alway be the default checkbox,the Inactive
checkbox, when checked I want it to deactivate the filing form and
automatically open up a new blank filing form.

Nov 13 '05 #1

Subscribe Post Reply

2359

PC Datasheet

Try the following:

Open your form in design view and select the option group (the box that
surrounds the two checkboxes). Go to properties, Data tab and set the defaut
property to 1. That should make the Active box the default. Go to the Events
tab and click on the AfterUpdate event and add the following code:
If Me!NmaeOfYourOptionGroup = 2 Then
Me.DataEntry = True
Else
Me.DataEntry = False
End If
This should give you what you want without needing a blank form.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdatasheet.com
www.pcdatasheet.com

"kufre" <ku********@yahoo.com> wrote in message
news:11*********************@o13g2000cwo.googlegro ups.com...

I need some help. I have a option group button that contain two
checkbox call Active and Inactive on my Filing form. This is what I
want, the Active box will alway be the default checkbox,the Inactive
checkbox, when checked I want it to deactivate the filing form and
automatically open up a new blank filing form.

Nov 13 '05 #2

Similar topics

Option group help for a beginner?

by: What-a-Tool | last post by:

I have a school project (ASP) in which I have to call three different ASP pages from three different and identical (except for the form "action", obviously) HTM pages. This I have no problem with....

Javascript

Cancel Change In Option Group

by: Corrine | last post by:

Is there a way to cancel a change in an option group? The option group still changes to the option clicked on when clicking on the NO button with the following code in the BeforeUpdate event of the...

Microsoft Access / VBA

I chose toggle buttons in my option group and now my option group isn't being updated when one of them is pressed

by: MLH | last post by:

Why is that? If I choose the tiny check boxes which are hard to hit with a mouse, it works fine. But option buttions, shich can be sized big enough for people with limited sight and dexterity...

Microsoft Access / VBA

Have on option group but need one of the option buttons when clicked to allow editing to a certain field

by: tsnyder | last post by:

I need to have an option button that allows editing to a field only when it is checked.

Microsoft Access / VBA

option button help

by: Stephen D Cook | last post by:

What I am trying to do is have a set of option buttons which are required to click one. If the person doesn't click any before insert, they get an error. If they do click one, it inserts into the...

Microsoft Access / VBA

option group and keyboard input

by: sparks | last post by:

When you enter an option group you can move to each option with the arrow keys and select with the space bar. Option groups don't have keydown events so has anyone come up with a way to allow...

Microsoft Access / VBA

Top option group button will not activate

by: sara | last post by:

Hi I'm having a very strange problem and need HELP!! I have a form for the user to choose a report (radio button in an option group) and parameters (Dates, Season). Click the option button,...

Microsoft Access / VBA

Option Groups

by: BarbaraB | last post by:

Is there anyway of returning the value of an option group (in access 2003) back to what it was before any entry was made? I frequenty find people are wishing to remove there answer but with an...

Microsoft Access / VBA

How to change option group button ForeColor dynamically?

by: tuxalot | last post by:

Another quick question for ya... Here's my button code, and I want to see if I can do something different so I don't have to repeat the same code for each of my 14 buttons in my option group: ...

Microsoft Access / VBA

How to turn on java script in a villaon keypad mobile phone

by: Charles Arthur | last post by:

How do i turn on java script on a villaon, callus and itel keypad mobile phone

Java

Basic Javascript concepts

by: aa123db | last post by:

Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...

Javascript

Batch import of multiple excel files into the database

by: ryjfgjl | last post by:

If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...

Data Management

Merging data from multiple Excel files

by: ryjfgjl | last post by:

In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...

Data Management

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

General

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

C / C++