Form/Subform

[statsman]

I have been asked at work to take a personnel database done in File Maker and convert it to Access. For the most part its not a difficult process except for the forms.

There is a main form with all of the relevant information (date hired etc.) but I require 3 subforms that contain personal information. These are labelled
“Personal” home address, home phone, home email
“Emergency” Emergency contacts in case of accident etc.
and “Training” requests the individual has made for training and courses they have been sent on

In File Maker the subforms have tabs which you click to open or close. The “Personal” sub form (for example) opens with all of the relevant info while the main form still stays on the screen. You then click the tab again and it closes. They would like something similar to this in the Access form. Problem is, I don’t even know where to start looking.

Would some kind person point me in the right direction.

 

[edtab]

In a nut shell, this is what you need to do:

Create a new form.
Choose a record source for your new form
Insert a "Tab Control" on the form.
Create text boxes on the tab control
Choose control source for each text box.

This should point you in the right direction and a good start.

Let me know if you need more help.

 

[statsman]

Exactly what I was looking for (I knew there had to be a way to do it).
Works great.
Thanks