Requery (1 Viewer)

[Avaughan]

What is the correct syntax for Requery.

I have a form with two sub forms. I need to update the underlying query for subform2 when I add registers to subform 1.

Works with macro but would rather use code

 

[BadOkie]

Hey Avaughan,

Sounds like you have it working the way you want with a macro. If that's true then you can go to design view of the form that contains your subforms and macro then click on Tools/Macros/Covert Forms Macros to Visual Basic. Access would then convert your macro that's working into code for you.

HTH
Shane

 

[AnnPhil]

put this code in the afterupdate event of subform1

subform2.requery

also put the code in the forms oncurrent event.