Form

[sarisri7]

Dear group members,

frankly saying, i am a kid using ms access.

i got some troubles in form page development.

1. how to auto link between two boxes in a form page
example: let me say Gender is check box, when selecting the gender check box, how can automatically enable the other Sex combo box (containing Male, Female) beside to Gender check box.

2. how to use IIf function in queries. Please give me your explanation with practical examples/sample data.

thanks a lot if i could get any solutions.

sarvesh.a

[hjozinovic]

Hi, and welcome!

To answer your first q.
1. In after update event (Code builder) of your check box Gender put a code like this:

Me!cboSex.Enable = True

( In this example cboSex is name of your combo box Sex)

2. To use iif() function you should look up your access help wher you can find explanations and examples.
Also you can search this forum on that term.

Example would be:
Open query in a design view.
Go to new column and write something like this:
Title: iif(Gender = "Male"; "Mr."; "Mrs.")

This will create new column in your query. It will be named Title.
It reffers to the field Gender that we presume already exists in your query, and holds values (Male or Female).

NB: Instead of ";" you might want to use "," in iif() function depending on your local settings. I'm from Croatia so I use ";"

Regards