Open subform based on textbox, move cursor to subform for new entry.

[J355Y1]

Hi,
I have a form which has two subforms in it. The form is called "frmAddEntry" which also has a combobox which displays students names and a textbox which displays student genders according to which student is selected.

Question1: How do i get my subforms to be invisible and only appear showing the suited information based on Gender once a student name is selected from the combo box?

The subforms are called "subfrmLstEntries" and "subfrmAddEntries"
Once the subforms become visible showing suitable records..

Question2: How do i get the focus/cursor to move to subfrmAddEntries ready to add a new record??

Thanks!

 

[MStef]

Send a short example of your MDB, (Access 2000 or 2002-2003).

 

[J355Y1]

I am using Access 2007. I have attached the database I am working on and the form i am working on within the database is frmAddEntry which has two subforms subfrmAddEntries and subfrmLstEntries..

Does anyone know how to do either of my questions..

Question1: How do i get my subforms to be invisible and only appear showing the suited information based on Gender once a student name is selected from the combo box?

Question2: How do i get the focus/cursor to move to subfrmAddEntries ready to add a new record??

Thanks!!