Help on Logic Building........Urgent

[Murali]

Hi,
Can any one help me with the Logic building:

There are user generated Codes like(codes-Description) c001-price,c002-qty.These may vary depending on the user.
These codes description has to be mapped to fields present on the form at run time like price to text1,qty to text2 so on....

Thanx
Murali

[OneSource]

Hi Murali,

It's hard to give a more specific response than this because you didn't give a lot of information about your project. But maybe this pseudocode will help you out:

Do Until EOF(User Generated Codes)
    Select Case Left(User Generated Codes, 4)
         Case "c001"
              'price
              text1 = Right(User Generated Codes, 5)
         Case "c002"
              'qty
              text2 = Right(User Generated Codes, 3)
         'And so on for other User Generated Codes
    End Select
Loop

I hope this helps.