Auto Refresh a Form & Sub Form

[scoobypaw]

I have created a form with a subform and need it to auto refresh when a new name is added to the list table.

The way I have the forms setup is if the sales person is not on the drop down list you link to the name table via a command button and add the name. However once you close the name table the drop down list is not refreshed. I need the form and subform to refresh with the new name that was added.

Thanks !

 

[PHV]

In the Click event procedure of the button open the name form as modal (acDialog) and then play with the Requery and/or Recalc methods.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[scoobypaw]

I am stuck on this error
"Object doesn't support this property or method"

Here is what I have done so far.....
On the click event of the button that opens the name table I added:

stDocName = "frmInputBCAnchorName"
DoCmd.OpenForm stDocName, , , stLinkCriteria, , acDialog
Forms!frmLetterApprovalNewCase![BC Anchor].Form.Requery

But it is giving this error and I can't figure out how to fix it.

 

[PHV]

What is [BC Anchor] ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[scoobypaw]

BC Anchor is the name of the combo box that needs to be updated on the form (frmLetterApprovalNewCase)

 

[PHV]

Either:
Forms!frmLetterApprovalNewCase![BC Anchor].Requery
Or:
Forms!frmLetterApprovalNewCase![BC Anchor].RowSource = Forms!frmLetterApprovalNewCase![BC Anchor].RowSource

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[scoobypaw]

YIPPEE.....Thanks it works now !