blank data from form

[kes]

hi all,

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



I have 3 tables: projects, items, items per presses and I have 4 forms: 1 for entering project name and pm name. in the second form I'm entering items for the project I've entered in form 1.
I'm using the code: =[Forms]![screen0]![Project_Name].
the code works and shows me the name of the project I've entered in form 1 in form 2, but when I'm entering the table itself in the project name I have blank where the project name supposed to be!

how can I fix that?

thanks!

[burrina]

Sounds like your tables are not linked. Are those subforms?

[Missinglinq]

Sorry, but I've read this five times and I have absolutely no idea what

...but when I'm entering the table itself in the project name I have blank where the project name supposed to be...

means!

As burrina has suggested, this type of scenario is usually handled by using a Main Form/Subform construct. The Main Form would be based on the Projects Table, the Subform based on the Items Table, and the two linked (via the Link Master Fields/Link Child Fields Property of the Subform) using the Project Name. The Access Gnomes would then automatically insert the ProjectName into the Records on the Subform.

Linq ;0)>

[kes]

hi,
first of all thanks for your help.

burrina
what do you mean linked? they are linked by relationships.

Missinglinq

I have a project name based on a previous form and in the current form I'm entering items list for this project, but in the actual table there is a blank in project name .

maybe the pictures will help clarify what I meant.

[orange]

As you can probably see fro the responses so far, readers have little idea of what your database is about or what your database structure is. Readers can't assist you until they have some understanding of your business issue/opportunity.
I recommend that you tell us all - in plain English - what your business is; what the issue is and what exactly you need assistance with. The more you can use plain, everyday English, and stay away from Access or other jargon the better.

Once people understand WHAT you are trying to do, I'm sure they will respond with options of HOW to accomplish it.

Good luck.

[kes]

hi,
ok , I just did the subform again and suddenly it worked! so thanks anyway!
but I do have another issue so I will explain the tables first...

I need to make table for projects include name, manager name and due dates. another table is for Items for those projects. each project have a few items and each item containtes a few types of presses.
in one form the users enters the project name and in the other form the items for the project and the press they need for each item.

I'v attached a zip file.

the question is: when I'm trying to enter a name of an item that already exist in another project I get the following error: "the microsoft access database engine cannot find a record in the table with key matching field".
I'm guessing it's something about the realtionship type, but I don't know how to fix it. I'v tried to change the type and to change to duplictes ok but still the same problem.

I hope now you understand what I mean. thanks againDB3 - Copy.zip