Accessing filenames programatically

I am trying to access the fields in an access table, through an ado
recordset, (which works), but I am trying to loop through the filenames in
the table progamatically. The fieldnames are as follows...

Mon_type1
Mon_type2
Mon_type3
Tues_type1
Tues_type2
Tues_type3
Wed_type1
Wed_type2
Wed_type3

I have tried doing it by filling a couple of array's as...

Text(2)
text1
text2
text3
....for the textbox name...

Day(2)
Mon_
Tues_
Wed_

and

Field(2)
type1
type2
type3

concatenating the day & field from the array's together

fieldname = Day(x) & Field(x)

and then looping through and painting the form with something like...

forms!frmInfo!!(text) = (fieldname)

and looping through something like that, but access is having problems with
(fieldname) even though it is enclosed with paren's. I have looped through
the textboxes on a form like this successfully and thought that looping
thfieldnames would be just as easy, but it doesn't seem to be working out.

Does anyone know how to refer to this ? Is it even possible ??

Ideas ?

TIA !!!

Michael
.

Relevant Pages

  • accessing fieldnames programatically
    ... recordset,, but I am trying to loop through the filenames in ... ....for the textbox name... ... fieldname = Day& Field ... and then looping through and painting the form with something like... ...
    (microsoft.public.access.modulesdaovba)
  • Re: Accessing filenames programatically
    ... > recordset,, but I am trying to loop through the filenames in ... > ...for the textbox name... ... > fieldname = Day& Field ... > and then looping through and painting the form with something like... ...
    (microsoft.public.data.ado)
  • Re: Disabled Panel control loses viewstate
    ... i'm going the route of looping through the panel's ... I don't know if deficiency is the right word. ... since the TextBox value should be returned on postback. ...
    (microsoft.public.dotnet.framework.aspnet.webcontrols)
  • Re: Annoying decimal point
    ... Try using an expression in the textbox on the report, ... replacing X with [FieldName] ...
    (microsoft.public.access.gettingstarted)
  • Referencing textbox
    ... Im trying to set value of a textbox, ... Fieldname is positively correct. ... Dim txtBox As New TextBox ... Dim obj As Naturgas ...
    (microsoft.public.dotnet.framework.aspnet)