Dear all
I have a form in Access and want to change the control source of a text box based on value selected in List box by user.
What i have got is:
Two tables namely TableA & TableB. Both of this table have three field ID, Part & ISR. This field are labelled same for both of this table.
I have got a form with an unbound List box having value X & Y. On the same form i have got an unbound text box name "Part". Now when the user select X in list box, then the control source of text box "Part" should be set to Part field of Table A. And if user select Y in list box, then control source of text box "Part" set to Part field of Table B.
Could anybody please help me in doing this.
Please help. All help will be highly appreciated.
I am attaching my database just for refrence.
Regards
SD
I have a form in Access and want to change the control source of a text box based on value selected in List box by user.
What i have got is:
Two tables namely TableA & TableB. Both of this table have three field ID, Part & ISR. This field are labelled same for both of this table.
I have got a form with an unbound List box having value X & Y. On the same form i have got an unbound text box name "Part". Now when the user select X in list box, then the control source of text box "Part" should be set to Part field of Table A. And if user select Y in list box, then control source of text box "Part" set to Part field of Table B.
Could anybody please help me in doing this.
Please help. All help will be highly appreciated.
I am attaching my database just for refrence.
Regards
SD
