data from form problem

[kes]

hi all,

I'm new in access, so I hope you can help me.

I have 3 tables: 1 for tables, 1 for items and 1 item per presses.
and 4 forms: 1 for entering the project name and pm name, 2 for entering items for the project name I've entered in form 1.
I used the code: =[Forms]![screen0]![Project_Name]. the code works and shows me the project name in the second form, but when I'm entering the table itself (items per presses) the project name is blank in the table! meaning no data for project name! how can I fix that?

I'm attaching the file, it's not really xls. please change the format to accdb.

thanks!

 

[JHB]

You must use the TextBox DefaultValue Property and set the ControlSource for the textbox to Project_Name.
I've attached the modified database.