Yes. If the Link properties are based on the combo boxes, then a Requery of the
subform control is what you need.
John Viescas, author
Microsoft Office Access 2010 Inside Out
Microsoft Office Access 2007 Inside Out
Building Microsoft Access Applications
Microsoft Office Access 2003 Inside Out
SQL Queries for Mere Mortals
http://www.viescas.com/
(Waco, TX)
-----Original Message-----
From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Duane
Sent: Wednesday, February 22, 2012 11:42 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Re: Refresh Sub Form
Bill,
What do you mean by "based on two combo boxes"? Are the subforms filtered by the
combo box values? If so, can you provide the record source of the subform? Are
the combo boxes in the subform or main form?
I think you might need to requery the subform after either combo boxes is
updated.
Duane Hookom
MS Access MVP
--- In MS_Access_Professionals@yahoogroups.com, "agent1of6" <Bill.Singer@...>
wrote:
>
> I am getting mixed results with my sub forms. I have a sub form based on two
combo boxes. I would like the sub form to refresh after either of the combo
boxes is changed. So in the "after update" property of each combo box what
should I use? Requery? RefreshRecord? Refresh?
>
> Thanks for your help.
> Bill
> MN
>
------------------------------------
Yahoo! Groups Links
Tidak ada komentar:
Posting Komentar