Hepl me make this form...

[nokia6230ivn]

I want to make this form by Access but don’t know how.
(please see att file!!!)

The title (1). I already make.
No.2: I want to make a dropdown, and that have 2 column. The first is short name of project, and the second is full name of project. After users choose, result is the full name. Data was take from “ProjectName” table.
No.3: It’s a text box which was typing by users.
No.4 and No.5: It’s a dropdown, which users choose the name at (4), (5) have the correclative result on “PositionSupervisor” table.
No.6: It’s a table have only 3 rows now, but If user need, it’s auto add more.
No.7 and No.8: It’s a textbox which user can typing anyone remarks.

I’m just study access so don’t know much about it. Every body help me...

 

[agehoops]

1. You've already done (title)

2. For a drop-down box, open the toolbox in the forms design view, and create a combo box. Go through the combo box wizard, and tell it to lookup values from a table. Select the fields you want it to show and finish the wizard. In the properties of the combo box, change the "Bound Column" property to the column number of the data you want it to use.

3. Simply create a text box, and change its control source to the field of the table you want it to enter data into

4. 5. Another combo box (same as step 2)

6. Insert a subform to show data from the table you want

7. 8. insert another text box of any size you like and make the control source the field of the table you want the data to go into.