Conditional filling a textbox

[Rob_R]

Hi,



I would like to know if it is possible to fill 8 textboxes on a form depending on the last two letters/digits. This is so I can "draw" a plate that can receive electronic cards. The numbering of the slots for the cards is something I have to deal with this because it is read like that from a textdump. There are 8 slots, the slots can be numbered from 01 to 08, or the first two slots can also be 00 and 00, and the slots can end with a letter, like AA BB CC DD. The table I read from might not have all slot occupied and then the textbox should be empty (space for a new card) I will try to clarify this in the table below.

0 or 1 or A (slot 1)	0 or 2 or A (slot 2)
3 or B (slot 3)	4 or B (slot 4)
5 or C (slot 5)	6 or C (slot 6)
7 or D (slot 7)	8 or D (slot 8)

Normal cards end with a number from 1 to 8. Redundant communication cards are always in slot 1 and 2 but the name ends with 0 and redundant non communication cars end with a letter A to D.
Example:
AI03 goes in slot 3
CM00 goes in slots 1 and slot 2
AI0D goes in the slots 7 and slot 8.

So if there are cards in the table I would like to see the textboxes fill like this:

CM00	CM00
AI03
AI0D	AI0D

Thanks in advance,
Rob.

[Welshgasman]

So what happens when you have three CM00 ?

[Micron]

So what happens when you have three CM00 ?

My guess is that the data only contains 1 of CM00 but the rule would mean it needs to occupy 2 slots. I imagine that code is the only solution for this, given the amount of logic involved and the suggestion that there is a data dump of some sort that one has to deal with. If there is a way to use only a query to get the data into a table of 8 fields that the form controls are bound to I'm not seeing it.

[Rob_R]

So what happens when you have three CM00 ?

Well, that is impossible. What I am trying is to visualize is a cabinet with 4 baseplates with 8 cards per baseplate. Only the first baseplate can have two communication modules in slot 1 and 2. The computer system wont allow to program more com modules at any other slot. There can be much more com modules in the system but only in other cabinets.

Regards,
Rob.

[Rob_R]

My guess is that the data only contains 1 of CM00 but the rule would mean it needs to occupy 2 slots. I imagine that code is the only solution for this, given the amount of logic involved and the suggestion that there is a data dump of some sort that one has to deal with. If there is a way to use only a query to get the data into a table of 8 fields that the form controls are bound to I'm not seeing it.

That is correct, the com modules are listed once in the data and the same goes for the redundant modules (A,B,C, or D)