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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

MS Access 2010 Training database 0
MS ACCESS query 5
HELP! UPDATE command tsql syntax and sql access syntax 8
Copy previous record into form field 0
SUBQUERIES in the FROM clause with Access query 3
Return a value from another table 4
Two tables, one form 3
Clearing Fields in a Word Form 5

Top