need help with syntax

[lance]

Hi all,

I was hoping someone could help me with a rather simple syntax
question:

I have a variable called "partnum" and "partslist" ... "partslist" is
a currency value amount.

I have on a form (form is called "invoices") 4 different text boxes,
partscharge1 , partscharge2 , partscharge3 and partscharge4 .


all I want to do is make the appropiate text box equal to the
"partslist" variable. By appropiate I mean the value of "partnum"

Here is the line I need the proper syntax for:

Forms![invoices]!partscharge<<partnum variable>> = plist



The above line is the wrong syntax........ If partnum = 4 it should
be equal to:

Forms![invoices]!partscharge4 = plist

If partnum = 3 then I would want it to equal to the statement:

Forms![invoices]!partscharge3 = plist


Basically , instead of having to type the actual number, i want that
number to be gotten from the variable "partnum"

could someone kindly give me the correct line syntax.... I'm know
very little about vb coding and need help with this simple
question.

Please email me at (e-mail address removed) - your help is so much
appreciated!!

 

[lance]

Hi all,

I was hoping someone could help me with a rather simple syntax
question:

I have a variable called "partnum" and "partslist" ...  "partslist" is
a currency value amount.

I have on a form (form is called "invoices") 4 different text boxes,
partscharge1 , partscharge2 , partscharge3 and partscharge4 .

all I want to do is make the appropiate text box equal to the
"partslist" variable.  By appropiate I mean the value of "partnum"

Here is the line I need the proper syntax for:

Forms![invoices]!partscharge<<partnum variable>> = plist

The above line is the wrong syntax........  If partnum = 4 it should
be equal to:

Forms![invoices]!partscharge4 = plist

If partnum = 3 then I would want it to equal to the statement:

Forms![invoices]!partscharge3 = plist

Basically , instead of having to type the actual number, i want that
number to be gotten from the variable "partnum"

could someone kindly give me the correct line syntax....  I'm know
very little about vb coding and need help with this simple
question.

Please email me at (e-mail address removed) - your help is so much
appreciated!!

Sorry, I got things mixed up, at the beginning I said I have two
variables, the second called partslist --- I meant plist .