Textbox and check box(Yes/No)

[Abdulaym]

Good day,


Please I have a textbox that contain numbers e.g. 3000 and when I select the option Yes I want the 3000 to go to a field in the table i.e. "CASH' and when I select the option No it should go to a field in the table i.e. "POS". Please how do I go about this?Thanks

[Micron]

Doable with code, but why complicate things? If this is, for example, a table of transactions, your textbox should be bound to the amount field (as I imagine you have done). Then a combobox bound to the transType field (my name for it) with 2 options - POS and CASH should put one of those values in the transType field.

[June7]

Agree with Micron. A record can be only POS or CASH so two fields for amount is not correct design.

Have one field for Amount and one field for TransType.

[Abdulaym]

Okay thanks for your response sir, I will try it sir

[Abdulaym]

Agree with Micron. A record can be only POS or CASH so two fields for amount is not correct design.

Have one field for Amount and one field for TransType.

Okay thanks for your response sir, I will try it sir

[Abdulaym]

Doable with code, but why complicate things? If this is, for example, a table of transactions, your textbox should be bound to the amount field (as I imagine you have done). Then a combobox bound to the transType field (my name for it) with 2 options - POS and CASH should put one of those values in the transType field.

Okay thanks for your response sir, I will try it sir