Var in Field Name

[Chris B]

I am trying to pass a varible and use it in a field name
that is to be set. The field names are FLD_NA,
FLD_NB,...FLD_NZ. What I want to do is pass it a single
letter like "C" and use it something like FORMS!Orders!
FLD_N & "C" = 100. HELP!

Chris

 

[Dirk Goldgar]

I am trying to pass a varible and use it in a field name
that is to be set. The field names are FLD_NA,
FLD_NB,...FLD_NZ. What I want to do is pass it a single
letter like "C" and use it something like FORMS!Orders!
FLD_N & "C" = 100. HELP!

Chris

Dim strFieldSuffix As String

strFieldSuffix = "C"

Forms!Orders.Controls("FLD_N" & strFieldSuffix) = 100

 

[TC]

If your form or table has fields like FLD_NA, FLD_NB, ... FLD_NZ, it sounds
like your table has not been normalized.

If you are not sure what "normalized" means, try the following article:

http://support.microsoft.com/support/kb/articles/Q100139.ASP

If this is off-beam (& you know exactly what normalized means), I'm just
tryin' to be helpful!

HTH,
TC

 

[Chris B]

THANKS DIRK

-----Original Message-----


Dim strFieldSuffix As String

strFieldSuffix = "C"

Forms!Orders.Controls("FLD_N" & strFieldSuffix) = 100

--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)


.