Display multiple forms on 1 screen

yep, you need 'subforms'. you can have up to 7 nested levels. or consider a tabbed form. what is your application? what is your version of access?

I am using Access 97.

Is it possible to include within a tabbed form details from a variety of tables which are not related as I am asked to create relationships when I use the Form Wizard

Another option (which may appeal if you already have the 3 forms created separately), is to allow all 3 of the forms in question to be open at the same time. This is pretty simple to do?just keep in mind that when you refer to each of the forms within your VBA code you?ll need to provide the entire ?path? to a control, where you don?t need to do that with just one form open.

With 1 form open you can refer to a control like this: txtFirstName = ?Bob?
Or Me.txtFirstName = ?Bob?, where txtFirstName is your control.

With multiple forms open you?ll have to be sure that you refer to the form name (unless the control you wish to call is located on the active form) like this:

Forms!frmEmployees!txtFirstName = ?Bob?

Hope this helps.

This question was auto-closed because it is 90 days old

This question was auto-closed because it is 90 days old