How to set value in combobox2 if combobox1 has value

M

meprad

Registered User.
Local time
Tomorrow, 01:59
Joined
Sep 12, 2012
Messages
14
Dear friends,
I have two combo boxes in Access form. what i want here is, lets say combo1 = "A" (selected) then I want combo2="x" (desired value to be set as "X") otherwise combo2 should remain blank.
Note that combo1 has its list A,B,C and combo2 has its list X,Y,Z. Your help is well appreciated.

thanks

Prad
 
In the after update event of Combo1 put

Code: 
Select Case Combo1
    Case "A"
        Combo2="x"
    Case "B"
        Combo2="y"
...etc
End Select
 
I am sorry i was not very clear on lists of combo1 and combo2.
combo1 and 2 are pulled from separate tables with two columns. as described below

combo1 combo2
No. Category No. Keypoint
1 A 1 X
2 B 2 Y
3 C 3 Z

both combos have bound column 1 and count column 2
In this case how i simply get value at combo2 when i enter combo1 as A

thanks
 
So is it the source of combo2 you want to change? i.e. if A is chosen in combo1 then combo2 shows d,e,f and if B is chosen combo2 shows x,y,z?
 
sorry again for not being that clear. Its very simple but I find this difficult - what i want is if i select "A" from combo1, I want to have one value could it be "x" or "y" but of my choice.. there is no link between these two combos. is it possible ? after updating combo1, I want automatically pop, lets say, "y" at combo2 of the form. :-)

Thanks CJ for your help i know you have some better solution on this.

Prad
 
Sorry, I still don't understand

The solution offered here and in Pauls thread do what you appear to be asking
 
You must log in or register to reply here.

Similar threads

P
Solved Odd Behavior in a form
Replies
7
Views
668
pdesantis8791
P
R
Solved Dreaded 'Write Conflict' error after adding a new field to Access form
Replies
12
Views
607
ricardocpa
R
R
Check if value exists in combobox and give user a prompt if they try to change it after it has been set
2
Replies
30
Views
929
RFreund
R
K
How can I add this code to the storage location of my file before scanning and then convert it to a PDF file?
2
Replies
25
Views
1,279
The_Doc_Man
The_Doc_Man
EdFred
Solved Want detail to not shrink, but it does...
Replies
3
Views
413
DHookom
DHookom

Users who are viewing this thread

Total: 1 (members: 0, guests: 1)
Back
Top Bottom