contional open a form and enter data

[tggsun]

Hello,
I'm a new to use Access 2007. I created 3 forms in access. The main one content a gender field. the other 2 forms, one for woman only, another one for man only.

I would like the access to do are:
when I select gender=man, the access will do, 1). check if there is any data was filled in woman only form. if there is, clean this out. 2). pop up the man only form to let user enter data. 3). after finished enter data in the man only form, click a button to save data and close the form.

do the oppsite things if gender=woman.



I would like to know how to do that and which book has the kind of information that I can learn from that.

Thanks,

dd sf

[KrisDdb]

Hello

Try this. You can have the option of selecting the gender on the main form in multiple ways.. buttons, radio buttons, checkboxes, dropdown list etc. Choose any one of these options and code the event to open only the form related to the gender selected. (code depends on the option you choose).Then in the open and close events of the second form, you can code it to close and open the master form alternatively. You set the visibility of the main form to FALSE for this. That would make it look good.

HTH

[tggsun]

Hello,
thank you for your information.
you mentioned "code the event to open only the form related to the gender selected". would you please let me know which book I can use to find out the way to code the event and some useful form design issue.
Thanks,
dd sf

[KrisDdb]

Access for Dummies 2007 - pretty generalized book and good to get you started. But not sure how far books can get you. You can rather try this

http://allenbrowne.com/tips.html

And there are tons of other sites to get you started with the coding. Good luck.

[tggsun]

thank you. I'll try.
dd sf