C
cmarsh
This is the setup.
Table A with 3 fields – Project, Name, Number
Table B with 5 fields – Project, Name, Number, Comments, Date
Main Page (data access page) with a hyperlink to Temp Page and a drop down
combo box displaying only the values of Project (from Table A)
Temp Page (data access page) that is connected to Table B to store the data
entered. On this page is 5 text boxes labeled to match Table B above.
Here is my problem. On selection from the drop down box from Main, and
selecting the link to Temp, I want the Temp Page to display only the records
that match the Project selected from the Main Page. Also, I want the Temp
page to fill in the Project, Name, and Number Text boxes from what was
selected.
How would I go about doing this? Thanks in advance!!!
Table A with 3 fields – Project, Name, Number
Table B with 5 fields – Project, Name, Number, Comments, Date
Main Page (data access page) with a hyperlink to Temp Page and a drop down
combo box displaying only the values of Project (from Table A)
Temp Page (data access page) that is connected to Table B to store the data
entered. On this page is 5 text boxes labeled to match Table B above.
Here is my problem. On selection from the drop down box from Main, and
selecting the link to Temp, I want the Temp Page to display only the records
that match the Project selected from the Main Page. Also, I want the Temp
page to fill in the Project, Name, and Number Text boxes from what was
selected.
How would I go about doing this? Thanks in advance!!!