multiple instance of a form

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

Guest

Can some please help me on the following

I have a form which opens up by entering a paramater - with taccontrol that
has about 10 pages
each page, each page has a sub form that uses a criteria based on a text boc
on the main form

I have set up a command button on the main form to open a new version of the
same main form code is as follows

Private Sub cmdopennewcust_Click()
Set frmx = New [Form_Entity Form]
frmx.SetFocus
End Sub

the problem that I am having is that the sub forms (on the tab control) on
the new form are not showing the new
data that refer to the new text box that appears on the 2nd version of the
form but are still showing the data
based on the first text box on the first form.

I tried to insert docmd.requery just above the End Sub above but that did
not work

clear as mud - any help would be apprciated.
 
Danny,

You shouldn't need to requery the subform. Make sure the LinkMasterField and
LinkChildField on the main form and subform are correct. When you change the
record on the main form, the subform should automatically change with it.

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia
 
Hi Graham

that worked - my ref was wrong.

I have another problem - I have posted as subject "Financial Statements" in
the report section - if you coul dhelp on that would be great posted on the
18 or 19th April


Thanks
regards
Danny


Graham R Seach said:
Danny,

You shouldn't need to requery the subform. Make sure the LinkMasterField and
LinkChildField on the main form and subform are correct. When you change the
record on the main form, the subform should automatically change with it.

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia
---------------------------

Danny said:
Can some please help me on the following

I have a form which opens up by entering a paramater - with taccontrol
that
has about 10 pages
each page, each page has a sub form that uses a criteria based on a text
boc
on the main form

I have set up a command button on the main form to open a new version of
the
same main form code is as follows

Private Sub cmdopennewcust_Click()
Set frmx = New [Form_Entity Form]
frmx.SetFocus
End Sub

the problem that I am having is that the sub forms (on the tab control) on
the new form are not showing the new
data that refer to the new text box that appears on the 2nd version of the
form but are still showing the data
based on the first text box on the first form.

I tried to insert docmd.requery just above the End Sub above but that did
not work

clear as mud - any help would be apprciated.
Click to expand...
Click to expand...
 
Back
Top