Tough forms question

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello gurus,

I have developed a form that has two fields that are related in one of my
databases, process and control number. For each process, there is a unique
control number in the table. On the form, I have two fields, a process drop
down menu, and a control number text box. What I would like to happen is when
I select a process from the drop down list, is have the control number value
for that process automatically populate in the control number text box. I
have tried various things that are not working. Any advice is appreciated.

Thanks

Rob
 
robk said:
Hello gurus,

I have developed a form that has two fields that are related in one
of my databases, process and control number. For each process, there
is a unique control number in the table. On the form, I have two
fields, a process drop down menu, and a control number text box. What
I would like to happen is when I select a process from the drop down
list, is have the control number value for that process automatically
populate in the control number text box. I have tried various things
that are not working. Any advice is appreciated.
Click to expand...
I assume the control number is the key field, it should be.
When you built the combo box it offered to hide this for you and then asked
what field you should store the value in. This is the same as the control
source.
Fill this in.
 
I setup a new combo box to see if this would work, and it did give me the
option to hide the key field, however, it did not ask me where to store those
values.

I have tried filling out the control source with the destination field, but
it's not working. Any other suggestions?
 
robk said:
I setup a new combo box to see if this would work, and it did give me
the option to hide the key field, however, it did not ask me where to
store those values.

I have tried filling out the control source with the destination
field, but it's not working. Any other suggestions?
Click to expand...
After you've set teh width of teh colums and hit next you shoud see a
window that gives you the option of saving or storing the value.
You want to store it.
 
Back
Top