John,
Upon further investigation, I went back to the linking properties and found
an error. The main form has a few drop down boxes. I had two subforms.
The first sub form was linked correctly so it updated after I put in the
Requery event. He second sub form contained a combo box base on a query
that was based on what happened in the first subform. The second subform
was not linked to the combo boxes in the main form. I was not able to get
the second sub form to update the query.
I think it was a bad design. I have redesigned my approach to getting the
correct information to show up and it will work better when I am finished.
Thanks,
Bill
MN
From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of John Viescas
Sent: Thursday, February 23, 2012 5:48 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: RE: [MS_AccessPros] Re: Refresh Sub Form
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%40yahoogroups.com>
[mailto:MS_Access_Professionals@yahoogroups.com
<mailto:MS_Access_Professionals%40yahoogroups.com> ] On Behalf Of Duane
Sent: Wednesday, February 22, 2012 11:42 PM
To: MS_Access_Professionals@yahoogroups.com
<mailto:MS_Access_Professionals%40yahoogroups.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
<mailto:MS_Access_Professionals%40yahoogroups.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
_____
No virus found in this message.
Checked by AVG - www.avg.com
Version: 2012.0.1913 / Virus Database: 2114/4827 - Release Date: 02/23/12
[Non-text portions of this message have been removed]
Tidak ada komentar:
Posting Komentar