tab cntrl

[database]

Hi evryone,

I have a form on which i have tabcntl. In my dB i have info about ppl and every perosn can belogn to one or more group. Now i need to have a cmd button which will ask me the group name and then when i enter a group, it will open one page of the tabcntl .

Can anyone tell me how to do this?

thanks a lot for ur help.

dB

 

[smercer]

use a macro with a "GoToControl" action. have the tab named and specify this in the macro

 

[Rich]

Forget the Macro, the SetFocus method will do, however there appears to be a design problem here. What if, as appears to be the case a person can belong to more than one Group?

 

[smercer]

Forget the Macro, the SetFocus method will do, however there appears to be a design problem here. What if, as appears to be the case a person can belong to more than one Group?

You can put in more than one SetFocus and a condition along with it

 

[Mile-O]

You can put in more than one SetFocus and a condition along with it

Nope. The correct answer is normalise the database.

 

[smercer]

Nope. The correct answer is normalise the database.

What do you mean by normalise. Normal from microsoft is not very user friendly.

 

[KenHigg]

db, How are your tables set up?