Pulled Over Links Not Saving

[dan.cawthorne]

Dear All,


I Was Woundering if some would could me with a slight Issue I Have,
Which to Forms. Regarding With Linking.

Situation

Form "Projects_QSearch" and form "Projects_Analysis"


The Q Search Form Opens a Form Where its Displays the Projects Details
of Projects Number IE Q559807

When I Open the Q Search Form The Results are there! Then What I Have
Is a Project Analysis Forms Which Can Be Open from this form, and have
Extra Additonal Fields Which is Saved into a Seperate Table.

But There's about 10 Fields The Same in this Form, So instead of the
User Having to retype all the Details again i have the following
expression

=Forms!Projects_Qsearch![Project Q Number]

And Changed The Field Name in the [ ] to suit each field And all the
details Pull Across into the fields.

Whats HAppening is when i Type Additional Items in the Fields thats
are not Pulled Across and save. the record.
When i Either Go Into The Related Table or Form that Views the Table,
The Items That Were Pulled Across Are Not Saving and the Fields are
Blank in the Table.

Does That Make Sense?

Dan

 

[jahoobob via AccessMonster.com]

In most cases you shouldn't store the same details in two tables. If the
tables are linked as you say, you can create a query of the two linked tables
and base your form on that. If you don't want the user of that form to
change the details of one of the tables, lock those fields.

Dear All,

I Was Woundering if some would could me with a slight Issue I Have,
Which to Forms. Regarding With Linking.

Situation

Form "Projects_QSearch" and form "Projects_Analysis"

The Q Search Form Opens a Form Where its Displays the Projects Details
of Projects Number IE Q559807

When I Open the Q Search Form The Results are there! Then What I Have
Is a Project Analysis Forms Which Can Be Open from this form, and have
Extra Additonal Fields Which is Saved into a Seperate Table.

But There's about 10 Fields The Same in this Form, So instead of the
User Having to retype all the Details again i have the following
expression

=Forms!Projects_Qsearch![Project Q Number]

And Changed The Field Name in the [ ] to suit each field And all the
details Pull Across into the fields.

Whats HAppening is when i Type Additional Items in the Fields thats
are not Pulled Across and save. the record.
When i Either Go Into The Related Table or Form that Views the Table,
The Items That Were Pulled Across Are Not Saving and the Fields are
Blank in the Table.

Does That Make Sense?

Dan

 

[dan.cawthorne]

In most cases you shouldn't store the same details in two tables. If the
tables are linked as you say, you can create a query of the two linked tables
and base your form on that. If you don't want the user of that form to
change the details of one of the tables, lock those fields.

Dear All,

I Was Woundering if some would could me with a slight Issue I Have,
Which to Forms. Regarding With Linking.

Form "Projects_QSearch" and form "Projects_Analysis"

The Q Search Form Opens a Form Where its Displays the Projects Details
of Projects Number IE Q559807

When I Open the Q Search Form The Results are there! Then What I Have
Is a Project Analysis Forms Which Can Be Open from this form, and have
Extra Additonal Fields Which is Saved into a Seperate Table.

But There's about 10 Fields The Same in this Form, So instead of the
User Having to retype all the Details again i have the following
expression

=Forms!Projects_Qsearch![Project Q Number]

And Changed The Field Name in the [ ] to suit each field And all the
details Pull Across into the fields.

Whats HAppening is when i Type Additional Items in the Fields thats
are not Pulled Across and save. the record.
When i Either Go Into The Related Table or Form that Views the Table,
The Items That Were Pulled Across Are Not Saving and the Fields are
Blank in the Table.

Does That Make Sense?

Dan

Well Thank you for the Promted Response,

If I Delete The Duplicate Fields Which are in the Enquiry Analysis
Table Which are the Same as in the Projects Table, And Correctly Link
The Table, So in The Enquiry Analysis Table I Just Have The Additional
Different Fields, Will Work,

Its When I Want To Create a Form, When The Commcerial Manager Opens,
He Can Still See The Project Details. From from the Required Project

Regards

Daniel