How control move on next field.

[yameen2011]

Hi friends i have a form containing these fields
trantype,Damount, Camount,Description
and trantype look-up field containing transaction type debit or credit.
Here in this form i want when i select debit transaction type then control move to the Damount and on pressing Enter key Camount skip and control move on Description, and same like this when i choose transaction type Credit then Damount skip away and control move on Camount field and next to description, and access doesn't ask for enter value in Damount is there any suggestion to make this.

 

[Mihail]

Take a look (google) to:
Got focus, Key press, Set focus

 

[bob fitz]

You may also want to look at setting the Enabled and/or Locked properties of the controls. This would need to be done with some code in the After update event of the "trantype" control (combo box?). The code would also be required in the forms On Current event.

 

[Solo712]

Hi friends i have a form containing these fields
trantype,Damount, Camount,Description
and trantype look-up field containing transaction type debit or credit.
Here in this form i want when i select debit transaction type then control move to the Damount and on pressing Enter key Camount skip and control move on Description, and same like this when i choose transaction type Credit then Damount skip away and control move on Camount field and next to description, and access doesn't ask for enter value in Damount is there any suggestion to make this.

Hi Yameen,
just a friendly pointer: the "trantype" field in your form assumes that the user knows whether the transaction is debit or credit. Therefore, it is redundant to restrict the entry into the other field. The user will intuitively enter the amount in one field and leave the other one empty. In the alternative, you can have just one amount field and a trantype dropdown which will determine whether the amount is debit or credit. Avoid unnecessary access manipulations !

Best,
J.

 

[Mihail]

Hi Yameen,
just a friendly pointer: the "trantype" field in your form assumes that the user knows whether the transaction is debit or credit. Therefore, it is redundant to restrict the entry into the other field. The user will intuitively enter the amount in one field and leave the other one empty. In the alternative, you can have just one amount field and a trantype dropdown which will determine whether the amount is debit or credit. Avoid unnecessary access manipulations !

Best,
J.

From my practice: never assume that the user will fill the expected control
But the "trantype" (finally I understand the meaning of this "word ) , indeed, is not necessary.

In fact I see 2 possibilities:
1) To keep the Damount and Camount and to manage, in the Before Update event, to have data in only one of this fields - "trantype" is no more necessary;
2) To replace the Damount and Camount fields with a general field Amount and to keep the "trantype" field.

I advice for 2)