[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
>

__._,_.___

Reply to sender | Reply to group | Reply via web post | Start a New Topic

Messages in this topic (2)

Recent Activity:

• New Members 9
• New Files 3

Visit Your Group

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use

.

__,_._,___