Linking controls in different tabs of one form?

Y

Yula

I am trying to create a database and I am having several issues. I would be
greatful if someone could advise me.

Here are some issues I am having.
1. I am trying to link to a combobox (Job#) on the "Main" tab and make the
text control automatically update in the "materials" tab. (All part of one
form). Based on what job # is selected in the main form, I want that
selection to automatically poplulate the job# text control in the materials
tab. I hope that makes sense.

2. Main form

Combobox: Category
Combobox: Job Name (depends on the category selected) - works fine
Combobox: Job# (depend on the job name selected) Using the same query as
above, only when i change the Category, the job# does not change.

My problem is that the job# does not change until I change the category and
select the job name. Any suggestions?


Thank you!
 
Top