Access 2016 Box combination, auto-list

[SoulGame]

Hello people !


I have two combobox that make the list function. I want to assign a number in a combobox and in the other combobox I want to see options X. How can I program the results according to the result of the first combobox?

attached image:



The option in 1 combobox:



Thanks !

[ranman256]

Cbo2's query uses cbo1 as the where clause.
select field2 from table where field1= forms!myForm!cbo1

once the user picks item in cbo1, you must refresh the list in cbo2, in the AFTERUPDATE event.

sub cbo1_afterupdate()
  Cbo2.requery
end sub

[SoulGame]

Cbo2's query uses cbo1 as the where clause.
select field2 from table where field1= forms!myForm!cbo1

once the user picks item in cbo1, you must refresh the list in cbo2, in the AFTERUPDATE event.

sub cbo1_afterupdate()
  Cbo2.requery
end sub

Where do I put the consultation?
And the cbo2 has numbers that are not in any table.
FORMER:
The option of cbo1 is '1', the options of cbo2 have to be {'1' - '2' - '3'}.
With a query this is possible?

Thanks for your help, and sorry for my lack of access.