Refer to control 1

[hoofit]

I have a document that discusses referring to form properties, controls etc if you're on the main form, subform and so on but I don't understand. I am on a combo box on the main form and I want to requery the main form after update of the combo box. If I'm on the form, what event do I use for after update of the cbox and how is it worded?

thank you,
hoof

 

[PHV]

Use the AfterUpdate event procedure of the combo ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[hoofit]

Hi PHV,
Yes I see that. I'm struggling with me.formSign!FORMS.requery or something like that. Can't recall the systax

 

[TheAceMan1]

How are ya hoofit . . .

That would be:

[blue]Me.Requery[/blue]

See Ya! . . . . . .

Be sure to see faq219-2884 [blue]Worthy Reading![/blue]
Also faq181-2886 [blue]Worthy Reading![/blue]

 

[hoofit]

omg I'm lost for words....

 

[hoofit]

I thought me. referred to the control you were on, not the form, thus the confusion