MS Access Form update

F

fi.or.jp.de

Hi All,

I using Access 2010.

I have two tables
table1
table2

table1 fields
change_number
status

table2 fields
change_number
date

i have created form as form1

under header i put new combobox = Row source from table2 DISTINCT date

Under details i need = if i select date from combobox, i need get the
change number and status which are available in table1.

Please provide step by step solution to populate the data.

Please help me
 
Top