I have a loop (see below) that references all the fields in a form. Is it
possible to restrict this to the detail section of the form?

For Each fld In frmSomeForm.Fields
rstSomeRst(fld.Name) = frmSomeForm(fld.Name)
Next fld

tia
las

On Sat, 16 Oct 2010 17:22:52 -0400, "LAS" <(E-Mail Removed)>
wrote:

>I have a loop (see below) that references all the fields in a form. Is it
>possible to restrict this to the detail section of the form?
>
> For Each fld In frmSomeForm.Fields
> rstSomeRst(fld.Name) = frmSomeForm(fld.Name)
> Next fld

One means might be to use the controls Tag Property and the Instr
function to find those controls. I prefer Instr rather than just
using an = should you decide to put multiple values in the Tag
property.

Tony
--
Tony Toews, Microsoft Access MVP
Tony's Main MS Access pages - http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
For a convenient utility to keep your users FEs and other files
updated see http://www.autofeupdater.com/

OK, thanks.

BTW - I see now, for this particular loop, that my question is academic,
because I should be using the rstSomeRst.Fields to drive the loop.

"Tony Toews" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> On Sat, 16 Oct 2010 17:22:52 -0400, "LAS" <(E-Mail Removed)>
> wrote:
>
>>I have a loop (see below) that references all the fields in a form. Is it
>>possible to restrict this to the detail section of the form?
>>
>> For Each fld In frmSomeForm.Fields
>> rstSomeRst(fld.Name) = frmSomeForm(fld.Name)
>> Next fld
>
> One means might be to use the controls Tag Property and the Instr
> function to find those controls. I prefer Instr rather than just
> using an = should you decide to put multiple values in the Tag
> property.
>
> Tony
> --
> Tony Toews, Microsoft Access MVP
> Tony's Main MS Access pages - http://www.granite.ab.ca/accsmstr.htm
> Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
> For a convenient utility to keep your users FEs and other files
> updated see http://www.autofeupdater.com/

"LAS" <(E-Mail Removed)> wrote in
news:i9d53c$alr$(E-Mail Removed):

> I have a loop (see below) that references all the fields in a
> form. Is it possible to restrict this to the detail section of
> the form?
>
> For Each fld In frmSomeForm.Fields
> rstSomeRst(fld.Name) = frmSomeForm(fld.Name)
> Next fld

I know you don't need the answer any longer, but you can do this:

For Each ctl In frmSomeForm.Section(acDetail).Controls
...
Next ctl

(the named constants for sections are actually rather hard to find
they are:

acDetail
acFooter
acGroupLevel1Footer
acGroupLevel1Header
acGroupLevel2Footer
acGroupLevel2Header
acHeader
acPageFooter
acPageHeader

These can be found by opening the Object Browser in the VBE and
searching for the acSection enum definition)

--
David W. Fenton http://www.dfenton.com/
contact via website only http://www.dfenton.com/DFA/

On 17 Oct 2010 00:27:45 GMT, "David-W-Fenton"
<(E-Mail Removed)> wrote:

> For Each ctl In frmSomeForm.Section(acDetail).Controls
> ...
> Next ctl

I knew there was an answer but I didn't quite feel like going through
the help and figuring i out.

Tony
--
Tony Toews, Microsoft Access MVP
Tony's Main MS Access pages - http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
For a convenient utility to keep your users FEs and other files
updated see http://www.autofeupdater.com/

Tony Toews <(E-Mail Removed)> wrote in
news:(E-Mail Removed):

> On 17 Oct 2010 00:27:45 GMT, "David-W-Fenton"
><(E-Mail Removed)> wrote:
>
>> For Each ctl In frmSomeForm.Section(acDetail).Controls
>> ...
>> Next ctl
>
> I knew there was an answer but I didn't quite feel like going
> through the help and figuring i out.

I could have cited my usual spiel on setting up custom collections,
and would have done so had it been a live issue...

--
David W. Fenton http://www.dfenton.com/
contact via website only http://www.dfenton.com/DFA/

Oh, thanks! I'm glad to know there is an answer.

"David-W-Fenton" <(E-Mail Removed)> wrote in message
news:Xns9E13D0291AFA4f99a49ed1d0c49c5bbb2@74.209.136.91...
> "LAS" <(E-Mail Removed)> wrote in
> news:i9d53c$alr$(E-Mail Removed):
>
>> I have a loop (see below) that references all the fields in a
>> form. Is it possible to restrict this to the detail section of
>> the form?
>>
>> For Each fld In frmSomeForm.Fields
>> rstSomeRst(fld.Name) = frmSomeForm(fld.Name)
>> Next fld
>
> I know you don't need the answer any longer, but you can do this:
>
> For Each ctl In frmSomeForm.Section(acDetail).Controls
> ...
> Next ctl
>
> (the named constants for sections are actually rather hard to find
> they are:
>
> acDetail
> acFooter
> acGroupLevel1Footer
> acGroupLevel1Header
> acGroupLevel2Footer
> acGroupLevel2Header
> acHeader
> acPageFooter
> acPageHeader
>
> These can be found by opening the Object Browser in the VBE and
> searching for the acSection enum definition)
>
> --
> David W. Fenton http://www.dfenton.com/
> contact via website only http://www.dfenton.com/DFA/