Data Type

I want to make a radio button for Male and Female selection on a data entry form, i can create the boxes and place them but how do i link them to the male/female field?

Cheers

Use an "Option Group" instead. This allow you to have a radio button for male and one for female. Only one object in this group can be enabled at one time. For example, if you click the female option, then the male option becomes disabled. Each object in the option group sets a value in which you define. This value is linked to the field in which you set.

Thanx dude, another thing ive just ran into is when i add a new record it loads the previous record details in the box, how do i make it so when i go to add a new record the box clears?

You would set that in the default setting of the option group

Not sure how you do that? I have selected all the options that i wish to be clear when the form loads, cant i just go into the properties and change a setting so they clear when the form is loaded?

Yes, go to the property setting for the option group and clear the default setting. During the setup wizzard for the option group, you probably did not noticed and set the default setting for the option group. You simply have to go back and blank out the default setting that was set. To access the property setting, just right click the option group box, not the objects in the box and select properties

All the details i have selected are not in an option group, they are just labels and txt boxes.

Ok, you kind of lost me. Did you create the option group as I mentioned at the beginning. If so, right click on the border that is your option group. This will enable the menu where you click on Properties.

The option group is just around the mal/female part. The rest of the record has all the persons details from the previous time i entered data when i load the forum up.

I believe he is not talking about his M/F field anymore, he is asking the general question of why a form shows data from a previous record.

This is a property of the Form. A bound form can be set to open in either Edit or Add mode. If you always want it to open to a new, blank record, and you are opening it, say, in the onClick event of a button, using VBA code, you will probably have a line somewhat like this in your code:which you will want to change to

I see where you are coming from but i cant find that line in my code. Here is a screenshot

http://i68.photobucket.com/albums/i4/Studders1/Form.jpg

I'm a little lost,.. are you saying that when you go to a new record the options you have selected on the previous record remain?

You might want to explain from the beginning whats happening here,

When i go to add a new record, the form loads and the details from the previous entry and still there. How do i change this so when i load the add record form the boxes are empty?

The command in your link refers to a click event and not to a on load event. In your present post, you refer to the form "loads". Are you saying that when you open the form the form that loads has records from previous entry. If this is the case, then what happens is that when the form loads, it will display all of your records, usually default to the first records.

Your code refers to a click event. Therefore, I assume you have a "add new record" button in your form. When you click on that button, does the form display a new record where all the fields are blank ready for new entry? Further, is the "add new" button in the same form as the form in which you will be adding new records?

Right i think this problem is being over-analysed lol.

Im in my database
I click Add_Student form
The form opens
the details of a student are already in the boxes

How do i set it so that when i open the form the boxes are clear.