Retrieving data from table(s)

[adamides]

I have two tables A and B, and I want to create a form where, using a combo box to select a value from a field in table A and then, using that value, to display in text box, values from a field in Table B that match the values of Table A.

Example: Select the date from Table A and display in a text box x items which are stored in Table B that have the same date as in Table A.

Can someone heLP?

 

[Rich]

Have a look at the solutions sample database supplied by MS. It's located in the samples folder or available from the MS Download site.
HTH