open subform in a new window?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have Access 2003. I would like to be able to open a related form from a second form. The subform functionality works well for me but it would be better if the subform opened in a separate window
Is this possible? If so how
My situation would a main table/form called patients, the other form/table would be patient visit data. They would be related by the patient id field
Please advise.
 
Hi

There are two methods both using the docmd.openfor

The Syntax for the docmd i
DoCmd.OpenForm formname[, view][, filtername][, wherecondition][, datamode][, windowmode][, openargs

Adding the following to a command button which uses the where condition
Docmd.OpenForm "[patient visit data]",,,"[patient id]='" & [patient id] & "'

You may need to remove the single quotes if the patient id is a numbe

Or you can utilise the openargs property

Hope this helps a littl
 
Back
Top