open subform in a new window?

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.
 
G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Close popup form from a continuous subform 3
Problem Re-initializing 1
Adding records to unbound subform 1
Filtering Subform PLEASE HELP! 3
showing a subform based on the main form 5
Can't get subform to synch with Parent 3
Populating control values based on each record on the many side 13
Show Record on subform based on current subform Line ID 1

Top