Tough Access Question for the gurus out there

[wyvrn]

I cannot figure this out, but I'm sure it's probably easy. First, take a look at the screenshot of the access form. What is shown is the top of a form. The first field, process, links to the second field, control_no, in a table. So for each process, there is a distinct control_no, such as 22.01, 22.02, etc..

What I want to happen is when I select a process from the drop down list, the corresponding control_no field updates with the right number. I have tried using subforms, queries and macros, but nothing works. I am ultimately trying to make the control_no field a text box and not a drop down list since it will only be displaying one value at a time.

If you can fix it, I can send some paypal love your way.

 

[KLin]

Check your PM

 

[wyvrn]

Pm'ed you back

 

[wyvrn]

I have a semi-working solution. Anyone else want to take a stab?

 

[AU Tiger]

Haven't done Access in ages, but here is what I came up with...

Set up your combo box (Combo0 for my example) with two columns, the second column being the value you want in the text box.

Example taken from a sample table I had:
Combo0 Row Source: SELECT Nml_inf_1203.INSURED_NAME_ID, Nml_inf_1203.INSURED_NAME FROM Nml_inf_1203;

In the Control Source for the text box put =Combo0.Column(1), the value will now change with the value chosen in the combo box.

 

[wyvrn]

Originally posted by: AU Tiger
Haven't done Access in ages, but here is what I came up with...

Set up your combo box (Combo0 for my example) with two columns, the second column being the value you want in the text box.

Example taken from a sample table I had:
Combo0 Row Source: SELECT Nml_inf_1203.INSURED_NAME_ID, Nml_inf_1203.INSURED_NAME FROM Nml_inf_1203;

In the Control Source for the text box put =Combo0.Column(1), the value will now change with the value chosen in the combo box.

I would like for the process, and control number fields to both be displayed. This option only displays one or the other (after selection). I know this has to be easy!

 

[NightTrain]

I did something similar with listboxes and used sql queries as the rowsource for each subsequent listbox based upon the selection on the previous. You can display however many fields and occurences you want.

 

[NightTrain]

CYPM

 

[GeekDrew]

YHPM

 

[wyvrn]

Thanks for all of the replies. I am going to use some of the suggestions here and work on this tonight!