Coding, data Entry In MS Access problem 1

[walz00]

Hi Guys,
I will really appreciate some help on this
I am Starting to learn Access and tryin to design a small database .
I have been experiencing problems with data entry and field properties.
1st problem : I have created some check boxes using the user group option using wizard, i have for example i created check boxes for gender
Male
Female
Unknown
Each being coded 1 2 and 3 respectively.
This seems to create problems in table and forms both as entering it on form doesn't give the right information on table ( isn't saved) or doesn't even save the info on the form on exit
Do i need to change field properties to text, number or ? in table design ?? if so what should i include?
I can use either male or female no hassles but i thought coding data as number will help later on .

Problem 2:
Same thing applies when i try to use the wizard to create a list box in a form and choose the values from a look up table this seems to not work either.

Guys my questions may sound stupid but I wuld really appreciate any help on it.

Thanks

Stressed

 

[Remou]

If you want information to be written back to the table, you need to bind the control to a field in the table or query by setting the Control Source property for the control, for this to work, you need to bind the form to the table or query by setting the Record Source property for the form.

It is often best to use the wizards when you are starting out, to do this, just make sure that the wand on the toolbox is clicked.

While it is generally better to use numbers and a look-up table, for something like Male, Female, Unknown, it is probably going to be easier in the long run to use the values, rather than the numbers, because, unless you are in the medical world, it is unlikely that you will need more than the three values named.

I strongly recommend that you read through the Northwind sample database that ships with every version of Access. It is full of hints and tips. Here is the 2000 download link:

http://www.microsoft.com/downloads/...72-8DBE-422B-8676-C632D66C529C&displaylang=EN

If you wish your databases to be properly set-up, you should understand relational concepts, this is very important:

http://www.r937.com/relational.html