General discussion

Locked

Display multiple forms on 1 screen

By MK1 ·
Is it possible to display multiple forms within 1 screen in Access ? I need to be able to reference 3 forms at the 1 time. Can I contain form within another ?

This conversation is currently closed to new comments.

14 total posts (Page 1 of 2)   01 | 02   Next
| Thread display: Collapse - | Expand +

All Comments

Collapse -

Display multiple forms on 1 screen

by sgt_shultz In reply to Display multiple forms on ...

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?

Collapse -

by MK1 In reply to Display multiple forms on ...

The question was auto-closed by TechRepublic

Collapse -

by MK1 In reply to Display multiple forms on ...

The question was auto-closed by TechRepublic

Collapse -

Display multiple forms on 1 screen

by MK1 In reply to Display multiple forms on ...

I am using Access 97.

Collapse -

by MK1 In reply to Display multiple forms on ...

The question was auto-closed by TechRepublic

Collapse -

by MK1 In reply to Display multiple forms on ...

The question was auto-closed by TechRepublic

Collapse -

Display multiple forms on 1 screen

by MK1 In reply to Display multiple forms on ...

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

Collapse -

by MK1 In reply to Display multiple forms on ...

The question was auto-closed by TechRepublic

Collapse -

by MK1 In reply to Display multiple forms on ...

The question was auto-closed by TechRepublic

Collapse -

Display multiple forms on 1 screen

by The Gun Doctor In reply to Display multiple forms on ...

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.

Back to Web Development Forum
14 total posts (Page 1 of 2)   01 | 02   Next

Related Discussions

Related Forums