Kevin,
You can refer to a specific field but the value will always reference the "current" record (the one with the focus).
Maybe if you told us what you are attempting to accomplish, someone can assist.
Duane Hookom, MVP
MS Access
________________________________
> Date: Sat, 24 Oct 2015 11:02:00 +0800
> Subject: [MS_AccessPros] Referring a field in a continuous subform
>
> Dear All,
> Is it possible to refer a specific field in a continous subForm? The
> reason I want to do it is because I have a combo box in the sub
> continuous form, and I want it show only contents restrained by another
> field in the subform, and I put something like
> =forms!frmMain!subForm!form.CountryID to restrain the field "City" in a
> query, but it turns out that it only restrained by the countryID from
> the first record in the subForm. No matter in which record the cursor
> is, the results stay the same... Please help. Thanks in advance.
> Best Regards,
> Kevin
Posted by: Duane Hookom <duanehookom@hotmail.com>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (2) |
Tidak ada komentar:
Posting Komentar