Full Version: forms and adding new records
UtterAccess Discussion Forums > Microsoft® Access > Access Forms
puttu123
Hi,

I am new to access. I have a project like this.

table 1 contain project no,project name,.......

table 2 contain project no, date received, date ended........


Now my problem is

1. How do i create a form for this?

2. Based on the project no selected from the table 1 i should enter the other details for table 2 and save itor even edit at times. For example my project no is A123.For this project no. upon selecting from the combobox i should enter the date received, date ended and many more fields and save it in the second table. How do i do this?

Can anybody help me pl.

thanks
puttu
ScottGem
Use a mainform/subform combo.
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.