Requery Subform control from form control change

[njwcad]

Can you please help. I am trying to requery a control on a subform after a change of a control on the main form. The query works once when I make my first change (after opening of the form) but will not requery if change the control on the main form for a second time. I have tried macros such as Requery and runsql but they do not work or my referencing is incorrect. For example I have tried to requery the subform control after change on the main form but a message pops up saying it Access doesn't recognise the name of the contro on the currnet form. Perhaps my referencing is wrong

Thanks

 

[PHV]

Have a look here:

http://support.microsoft.com/?kbid=209099

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

 

[njwcad]

PHV
Thanks for your help. However I have been trying for the last hour or so to reference this and the message goes something like "there is no field xxxxxxx in the current record" To explain further. I have a main form called "Raised PRS" and a subform called "Equipment Installs / Removals" with a control called "Equipment Type"

My reference in the Requery macro is
Forms![Raise PRS]![Equipment Installs / Removals].Form![Equipment Type]

I'm sure I'm probably missing something simple

 

[TheAceMan1]

How are ya njwcad . . .

From the mainform, try the following:

[blue]   [subFormName].Requery
or
   [subFormName].Form.Recalc[/blue]

See Ya! . . . . . .

 

[njwcad]

PHV - Thanks for your help.
[Equipment Install / Removals]![Equipment Type].Requery works fine