473,396 Members | 1,938 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,396 software developers and data experts.

Option group Question

I have a option group M F and is stored into a field called gender.

I also have a 2 text boxes on a form one called male one called female

What i want to do is when the user select m from the option group it
will display an X in in the text box called male if user selects F from
the option group it will display an X in the Text box called Female .
Any Ideas

Nov 20 '05 #1
9 1709
Put the following code in the AfterUpdate event of your option group:
If Me!NameOfOptionGroup = 1 Then
Me!Male = "X"
Me!Female = Null
Else
Me!Female = "X"
Me!Male = Null
End If

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

If you can't get the help you need in the newsgroup, I can help you for a
very reasonable fee. Over 1000 Access users have come to me for help.
Need a month calendar or 7 day calendar? Need appointment scheduling? Need
room reservations scheduling? Need employee work scheduling? Contact me!


<je********@gmail.com> wrote in message
news:11**********************@o13g2000cwo.googlegr oups.com...
I have a option group M F and is stored into a field called gender.

I also have a 2 text boxes on a form one called male one called female

What i want to do is when the user select m from the option group it
will display an X in in the text box called male if user selects F from
the option group it will display an X in the Text box called Female .
Any Ideas

Nov 20 '05 #2

"PC Datasheet" <no****@nospam.spam> wrote in message
news:eM***************@newsread2.news.atl.earthlin k.net...
Put the following code in the AfterUpdate event of your option group:
If Me!NameOfOptionGroup = 1 Then
Me!Male = "X"
Me!Female = Null
Else
Me!Female = "X"
Me!Male = Null
End If

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


A quick note to anyone reading this message thread. This newsgroup is an
excellent resource for getting help with your Access projects. If you feel
the need, however, to seek professional help, I strongly advise that you not
consider hiring this PC Datasheet character. Steve is a bright kid but is
totally unprofessional. There are literally hundreds of competent Access
consultants available. Many post regularly in this newsgroup, others can
easily be located by googling or visiting guru.com.

Nov 20 '05 #3

"PC Datasheet" <no****@nospam.spam> schreef in bericht news:eM***************@newsread2.news.atl.earthlin k.net...

<snipped all the advertising stuff>

To the OP: Beware of this guy!!

Steve just does *not* care about the newsgroups. He has *no ethics at all*.
Steve *only* cares about making money, and he acts as if the groups are his private hunting ground.

-- He is asking lots of ignorant questions here under different names because he is ashamed to ask *as* PCD.
-- He is giving lots of wrong or just plain stupid answers here.

Though he thinks he is a resource and advertises as such, he is not really what he thinks he is.
But he is always trying very hard to be very helpful to new people here ....

Look at: http://home.tiscali.nl/arracom/stopsteve.html

Arno R
Nov 20 '05 #4
Consider that this is posted by someone who blatantly lied in a post just
hours ago and now is trying to portray himself as your hero!! Is this the
kind of hero you want?
"Randy Harris" <ra***@SpamFree.com> wrote in message
news:3U***************@newssvr30.news.prodigy.com. ..


A quick note to anyone reading this message thread. This newsgroup is an
excellent resource for getting help with your Access projects. If you
feel
the need, however, to seek professional help, I strongly advise that you
not
consider hiring this PC Datasheet character. Steve is a bright kid but is
totally unprofessional. There are literally hundreds of competent Access
consultants available. Many post regularly in this newsgroup, others can
easily be located by googling or visiting guru.com.

Nov 20 '05 #5
"PC Datasheet" <no****@nospam.spam> wrote in message
news:Rq****************@newsread1.news.atl.earthli nk.net...
Consider that this is posted by someone who blatantly lied in a post just
hours ago and now is trying to portray himself as your hero!! Is this the
kind of hero you want?


So you admit you lied?

No, you are not my hero.

John... Visio MVP

Nov 20 '05 #6
Steve, nobody wants this crap in cdma. You can put a stop to it. Stop
advertising here. It's as simple as that.

Nov 20 '05 #7

"PC Datasheet" <no****@nospam.spam> schreef in bericht news:Rq****************@newsread1.news.atl.earthli nk.net...
Is this the kind of hero you want?


Yep ! This is the kind of hero I want.

*You* are *not* my hero; you are just a very lame coward Steve ...
You lied several times about me remember ?? I am still waiting for your answers !!

What are you "bulshitting" and shouting about again anyhow?
No matter how many exclamations (!!!!!!!!!!!) there is NO support for you.

Are you 'coming soon' with your answers, or just breathing heavily ??

Arno R
Nov 20 '05 #8
<je********@gmail.com> wrote in message
news:11**********************@o13g2000cwo.googlegr oups.com...
I have a option group M F and is stored into a field called gender.

I also have a 2 text boxes on a form one called male one called female

What i want to do is when the user select m from the option group it
will display an X in in the text box called male if user selects F from
the option group it will display an X in the Text box called Female .


Why do you want to do this? Wouldn't it be simpler to have to option group
bound to a Male/Female field? No code necessary and you only store the data
once.

Keith.
www.keithwilby.com
Nov 21 '05 #9
Keith W wrote:
<je********@gmail.com> wrote in message
news:11**********************@o13g2000cwo.googlegr oups.com...
I have a option group M F and is stored into a field called gender.

I also have a 2 text boxes on a form one called male one called female

What i want to do is when the user select m from the option group it
will display an X in in the text box called male if user selects F from
the option group it will display an X in the Text box called Female .

Why do you want to do this? Wouldn't it be simpler to have to option group
bound to a Male/Female field? No code necessary and you only store the data
once.


Or use a combo box.

Depending on the application there's sometimes more than just 2 options,
e.g. neutered (both M & F), hermaphrodite (M, F and true), not to
mention what you might find in Thailand (unless you do the Crocodile
Dundee test).
Nov 21 '05 #10

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
by: Stewart | last post by:
Dear comp.lang.javascript, I have more than once wanted to manipulate the contents of select boxes dynamically, whilst the boxes contain <optgroup> tags. Manipulation of a select box containing...
7
by: Shyguy | last post by:
I have an option group with about 30 options. I would like to have the Option Labels get their text from a table. Is this possible, and if so how? Also, is it possible to embad a font into a...
6
by: Robert | last post by:
Hello. I have been trying out the Lebans ToolTip Classes at http://www.lebans.com/tooltip.htm, to display "balloon" style help tips in a form. The classes I am using are located at...
2
by: Charles | last post by:
Ok, so I'm creating a form on the fly. I can create the option group, I can create the checkboxes, but I can't figure out how to bind them to the option group I'm creating them within. I was...
20
by: PC Datasheet | last post by:
How can the label for a checkbox and the labels for the options in an option group be addressed? When a checkbox gets the focus, Access draws a dotted box around the label. When an option group...
6
by: Chris Fink | last post by:
Does anyone know it is possible to include a small image(.gif .jpeg) within a <SELECT><option> so that the user would see the option text as well as a little image(icon) in the option? I know this...
22
by: Vijay | last post by:
With the option strict On set..... Dim fs As FileStream = File.OpenRead(strFile) With fs Dim buffer(fs.Length) As Byte ' <--- Option Strict On disallows implicit conversions from 'Long' to...
2
by: Thelma Lubkin | last post by:
I've been unable to find code for adding an option to an option group. I did find this instruction on a site called softlookup.com: "If you want to add another option button to an option group,...
21
beacon
by: beacon | last post by:
Hello to everybody, I have a section on a form that has 10 questions, numbered 1-10, with 3 option buttons per question. Each of the option buttons have the same response (Yes, No, Don't know),...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
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...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
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...
0
marktang
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,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
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,...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.