question How to manipulating textbox control source

[Andyleone]

Hello, i would like some advice/suggestion

I have 1 cbobox and 1 text box and table named as client with field named as job

first name as cbojob
cbocox value list is job1, job2, job3, other

if "other" selected in cbojob then the user had to type the job name in jobtxt.

there is some solution that i have seen..but result were not as i expected.

what i want know is how to transfer recordsource/controlsource(at textbox property) to jobtxt if "other" selected on cbojob. (if it can be done)

In simple word the job field (on table) that connected to cbojob (on form), go to jobtxt (on same form) if value other selected in cbojob.

 

[GinaWhipp]

Hmm, without much to go on I'm thinking an UPDATE query that can be run After_Update of the Other Text Box. You would then have to Requery the Combo Box to reflect the changes.