Two text boxes with the same Control Source

[Rachel B.]

Hi there,

I am new to Access. I am the only person in my office building who uses it, so hopefully someone here can help me. I use Access 2003.

I am working with a form that collects aggregate data. One field is for Gender. It has two text boxes. One of its labels says Male and the other label says Female. I'd like to be able to put a number next to Male and a different number next to female.

The problem I am having is they are using the same Control Source, which is a table called Gender. When I type a number next to Male and hit tab, the Female automatically fills with the same number. How can I separate them?

Thank you in advance for any help you can give me.

 

[boblarson]

You can't use a field like that. You need to have separate fields for the different genders or have one boolean field like True for Male and False for female.

 

[Rachel B.]

Thanks for the quick and helpful response, Bob!

 

[wjburke2]

Hey here is another solution. Grouped check boxs. Have the user select male or female. Grouped check boxes contain numbers on the database 1 for male 2 for female. This gives you the numbers and makes looking at the database data easier.

 

[Rachel B.]

Hey here is another solution. Grouped check boxs. Have the user select male or female. Grouped check boxes contain numbers on the database 1 for male 2 for female. This gives you the numbers and makes looking at the database data easier.

Thanks wjburke2!

Actually, that's how I originally set up the form. Then after I finished it and set it up on my supervisor's computer, he told me he needed it set up so he could, for instance, enter something like Males- 36 and Females- 117.

That would have been nice to know in the beginning