Requery a Subform

[scoobypaw]

Hello,

I have a mainform: frmLetterApprovalNewCase
With a dataview subform: frmApprovalLetterInput_Subform
2 combo boxs in the subform: Sales , Sales2

on the mainform I have a command button that takes me to another form so I can add names to a table which 2 combos are connected to through a query in the subform.

I have read most of the treads on Requery to see if any of the solutions work or me and I have not been able to get anything to work.

On the command button to open the add name form "on click" I added:
Forms!frmLetterApprovalNewCase!frmApprovalLetterInput_Subform.Form!Sales!Sales2.Requery

and I made the name form a diaglog

It is giving me this error message
"Property let procudure not defined and property get procedure did not return an object.

I am at a loss. I have changed it about 20 times it seems.

Thanks for your help.

 

[Remou]

Hi
If you have two combos, I think you need to requery like this:
[tt]Forms!frmLetterApprovalNewCase!frmApprovalLetterInput_Subform.Form!Sales2.Requery[/tt]

[tt]Forms!frmLetterApprovalNewCase!frmApprovalLetterInput_Subform.Form!Sales.Requery[/tt]

However, if you are changing the associated data in your Name form, I think you will need to requery on closing the Name form, not on opening it.

 

[scoobypaw]

Thank You Remou !!!!!

That worked. And yes I needed to put it on closing the name form.

Hats off to ya !
I was racking my brain for over a day on that one.