entryfields

[Jean-Paul De Winter]

Hi,
I have a form with about 12 entryfields named entryfield1 to entryfield13.
I must asign a value to this entryfields...
can I put the "entryfield" name in a loop like:

entryfield+x
x=x+1

where is is a value from 1 to 13

what is the correct syntax to do so?
Thanks
JP

--

Mvg.
Jean-Paul De Winter

Onze website....
www.kine-dewinter-deckers.be

 

[Allen Browne]

This sort of thing should do it:

Dim strField As String
Dim i As Integer
For i = 1 to 13
strField = "entryfield" & i
Me(strField) = i
Next

 

[Jean-Paul De Winter]

Great thanks...
Problem solved
JP

This sort of thing should do it:

Dim strField As String
Dim i As Integer
For i = 1 to 13
strField = "entryfield" & i
Me(strField) = i
Next

 

[Jean-Paul De Winter]

But... shouldn't I add a ! in your code?( in the strField)

Something like:

Dim strField As String
Dim i As Integer
For i = 1 to 13
strField = "!entryfield" & i
Me(strField) = i
Next
JP

 

[Allen Browne]

No.

The expression:
Me("MyField")
is shorthand for:
Me.Controls("MyField")

You don't need the bang for that construct.