Refresh form from report

[Crilen007]

I have a report that, when closed, I would like to refresh the main form, or subforms in it (Whichever is easier)


Main form: frmMain
Sub form A: subWebLCSel
Sub form B: subWebPartSel
Report: rptLabels


I tried:

forms!frmMain!subWebLCSel.form.requery- told me it cant find the field subWebLCSel

Forms!subWebLCSel.Requery - tells me it cant find the form subWebLCSel


Any ideas?

 

[maikon]

Try it:

Form_frmMain.subWebLCSel.Requery

Why:

"Form_frmMain" is the VBA form name, and not the access form name (normally frmMain).

[]s

 

[Crilen007]

Told me it couldnt find the form Form_frmMain

 

[Crilen007]

???

Anyone have any ideas on this?

 

[Pat Hartman]

Why would you want to requery a form in the close event of a report?

But you can do it. The form just needs to be open.

Forms!MainForm.Requery

or

Forms!MainForm!Subform.Form.Requery

 

[Crilen007]

Well, when they print the report. If it printed properly, it backs up some things so that only things that changed are printed, and then it clears the things that were selected (as they were selected on the internet by others).

Its a very cool Database, I should post it sometime, maybe get your comments on it. Ill try that form refresh.

 

[Pat Hartman]

Ill try that form refresh.

Refresh is not the same as Requery. Read about them in help so you understand the difference.

 

[Crilen007]

Yea, I did know the diff, sorry, just typed it wrong heh.

It worked perfectly, thanks =)

I was trying to use the name of the sub form as seen in the database window, not what the main form had it as, so I figured that out heh.

Thanks again.