I can not save the data from forms?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello
I have 5 tables releted & I have 2 forms
The first i choose data
the scuand one i use some of the felids from i use it from first form like
when i finsh the first form i click on cmd button and open the scound form
and i use this in data source "=forms!f1!m1" for all feilds that i need and
it is work fine i can see it in the form but when i try to save it , it is
not save the data !!! that from first forms !!!

thanks

khalifa
 
On Thu, 31 Mar 2005 13:31:07 -0800, khalifa m <khalifa
Hello
I have 5 tables releted & I have 2 forms
The first i choose data
the scuand one i use some of the felids from i use it from first form like
when i finsh the first form i click on cmd button and open the scound form
and i use this in data source "=forms!f1!m1" for all feilds that i need and
it is work fine i can see it in the form but when i try to save it , it is
not save the data !!! that from first forms !!!

thanks

khalifa
Click to expand...

Kalifa, if you use a Control Source referring to another form, the
data will not (and should not!) be stored.

What are the Recordsource properties of these two forms? Are you
trying to store data redundantly in a second table, using these two
forms to copy the data from one table to another? If so, DON'T - there
is no benefit and many risks to storing redundant data!

John W. Vinson[MVP]
 
hello john

yes I use a Control Source referring to another form,
you ask " What are the Recordsource properties of these two forms? "

the first one i have 3 tables and i choose from this like operator_name when
i click oper_name it open other form called problom and the oper_name and
some of info comes to the 2nd form i need those data from the 1st form to
store it in other table !!! how i can do it

thanks agien

khalifa
 
hello john

yes I use a Control Source referring to another form,
you ask " What are the Recordsource properties of these two forms? "

the first one i have 3 tables and i choose from this like operator_name when
i click oper_name it open other form called problom and the oper_name and
some of info comes to the 2nd form i need those data from the 1st form to
store it in other table !!! how i can do it
Click to expand...

You SHOULD NOT DO IT.

Storing data which exists in one table into another table is BAD
DESIGN. In a relational database, you should store information *once*,
in only one table; when you need that information together with
information from another table, you would create a Query linking the
two tables.

Stop, step back, and reconsider your table design! Creating an
elaborate form to do the wrong thing will not help you in the long
run.

John W. Vinson[MVP]
 
hi john

thank you sir

i am self study so i thought i can do it

ok i will try to learn more and try to do it with other ways

thanks again

khalifa
 
Back
Top