Requery a subform does not work in Office 2003

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have an Access program developed in Office XP. On a form with 2 subforms
the second subform is linked to the other with LinkMasterFields like
[subformname]![fieldname] In Office XP the right values are displayed after a
requery. in Office 2003 this does not work (It does, when I change the
LinkMasterFields to [subformname].{Form].[Fieldname]

Is there a Flag in Office with which I can get the behaviour of Office XP?

Regards,
Maarten Boskamp
 
There's not a flag for this, but there is a bug associated with this.

You are talking about a fieldname. Do you have a control for this field? Or
are you referring to a field in the subform's RecordSource that has no
control on the form? It really needs to be a control name to avoid this bug,
in both Access 2002 and 2003. So the reference you need in both versions is:
[subformname].[form].[controlname]

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

message
news:D[email protected]...
 
Maarten,

Here is a solution that should work in any version as well as future
versions.

Place a textbox on the main form and assign it as the LinkMasterFields
property of subform2. In the current event of subform one, assign the master
link value to the textbox. Then make the textbox invisible. This works
well.

God Bless,

Mark A. Sam
 
Back
Top