open multiple forms

  • Thread starter Thread starter Miranda
  • Start date Start date
M

Miranda

hi,

i was wondering if this is possible. i've got a form that you can select a
project from a combo box, another form then loads to view stuff about this
project. Is it possible to select multiple projects in the combo box and
therefore open multiple project info pages ?

thanks,
miranda
 
Miranda,

You can simply issue the DoCmd.OpenForm method using the ProjectID as the
argument.

Graham R Seach
Microsoft Access MCP, MVP
Sydney, Australia
 
Miranda,

It can be done from anything. You need to add VBA code to the control's
AfterUpdate event:
DoCmd.OpenForm "frmMyForm", ,"[ProjectID] = " & Me.lstMyListBox

Graham R Seach
Microsoft Access MCP, MVP
Sydney, Australia
 
hi,
I already have a similar openForm event, but i can only open one project at
a time using it. Are you saying that this should work if you want to open
multiple projects at one time?

thanks!
miranda


Graham R Seach said:
Miranda,

It can be done from anything. You need to add VBA code to the control's
AfterUpdate event:
DoCmd.OpenForm "frmMyForm", ,"[ProjectID] = " & Me.lstMyListBox

Graham R Seach
Microsoft Access MCP, MVP
Sydney, Australia


Miranda said:
can this be done from a combo box? or only list boxes?
select about
this
Click to expand...
Click to expand...
 
Miranda,

OK, my mistake. I wasn't thing properly.

The only way to open the same form multiple times is to borrow some
object-oriented programming techniques. Take a look at the way it's done on
this page http://www.pacificdb.com.au/MVP/Code/MyDialog.htm.

Read through it, and trace the code step-by-step, so you understand how it
works. Once you have a handle on what it's doing, you'll need to add a
method to filter the *dialog* to display the data you want.

Graham R Seach
Microsoft Access MCP, MVP
Sydney, Australia


Miranda said:
hi,
I already have a similar openForm event, but i can only open one project at
a time using it. Are you saying that this should work if you want to open
multiple projects at one time?

thanks!
miranda


Graham R Seach said:
Miranda,

It can be done from anything. You need to add VBA code to the control's
AfterUpdate event:
DoCmd.OpenForm "frmMyForm", ,"[ProjectID] = " & Me.lstMyListBox

Graham R Seach
Microsoft Access MCP, MVP
Sydney, Australia


Miranda said:
can this be done from a combo box? or only list boxes?
Miranda,

You can simply issue the DoCmd.OpenForm method using the ProjectID
Click to expand...
as
the
argument.

Graham R Seach
Microsoft Access MCP, MVP
Sydney, Australia


hi,

i was wondering if this is possible. i've got a form that you can
Click to expand...
select
a
project from a combo box, another form then loads to view stuff about
this
project. Is it possible to select multiple projects in the combo
Click to expand...
box
and
therefore open multiple project info pages ?

thanks,
miranda
Click to expand...
Click to expand...
Click to expand...
 
Back
Top