You can use the Link Master/Child properties to filter a subform based on the values on the main form.
Duane Hookom MVP
MS Access
> To: MS_Access_Professionals@yahoogroups.com
> From: daniel2478a@yahoo.ca
> Date: Sun, 4 Nov 2012 14:34:49 -0800
> Subject: Re: [MS_AccessPros] time tracking DB
>
> Hello,
>
>
> for my DB I have a modal dialog which contains couple sub forms
> i also have a combo box to select employee and test box to select date
>
>
>
> my questions are:
>
> 1. by selecting an employee from the combo box how do you filter a sub form list to show data only for that employee?
> using a text box with date used to filter sub form list would be similar i assume
>
> 2. i have 2 sub forms on the modal dialog, sub form "a" shows a small list that will be filtered by employee and date and sub form "b" will show detail of a record selected on sub form "a"
> how do you do filtering on that?
>
>
>
> thanks,
>
> d
>
> [Non-text portions of this message have been removed]
>
>
>
> ------------------------------------
>
> Yahoo! Groups Links
>
>
>
[Non-text portions of this message have been removed]
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (5) |
Tidak ada komentar:
Posting Komentar