0 Replies - 663 Views - Last Post: 24 June 2016 - 09:03 PM

#1 josef01  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 22
  • Joined: 19-March 11

Cascading combo box in sub form

Posted 24 June 2016 - 09:03 PM

I have a sub form with four fields’ field1, field2, field3 and field4. I want to auto display corresponding data in field2 when I select field1.
I have this in sub form

field1 | field2|
-------|-------|
A | B |
C | D |

When I select A in field1 I want field2 to display B

field1 | field2|
-------|-------|
A | B |


I have two tables in database table1 and table2 .
Table1 - ID, field1, field2, field3 and Table2 - ID, field1, field2, field3, field4
I have added fields by selecting table1 using sub form wizard. I have deleted field1 and added a combo box and renamed field1 bound to field1 of table1, a text box as field2 with control source =[field1].[field2]. It displays #Name? in field1. Can someone tell how can I do it?

Is This A Good Question/Topic? 0
  • +

Page 1 of 1