Update record

T

tony wong

i have ONE table (link with SQL) with 2 forms (Main Form A + Sub Form B)

The 2 forms switches between them.

when goto SubformB from MainFormA by button(macro), update some fields.

go back to MainFormA, it is not updated.

but in the table, it is updated.

when go again from MainFormA to SubformB and go back to MainFormA,

now it is updated.

everytime, i have to switch between them twice.

what's wrong with that?

2 forms use the same ONE table.

Thanks a lot.

tony
 
R

Rick Brandt

tony said:
i have ONE table (link with SQL) with 2 forms (Main Form A + Sub Form
B) The 2 forms switches between them.
when goto SubformB from MainFormA by button(macro), update some
fields. go back to MainFormA, it is not updated, but in the table, it is
updated.

when go again from MainFormA to SubformB and go back to MainFormA, now it is
updated. everytime, i have to switch between them twice.

what's wrong with that?

2 forms use the same ONE table.
Click to expand...

Normally a bad idea to have two forms trying to edit the same record in the same
table like that. Can you explain why you are using two forms? Often this will
even produce write conflict errors because to the database it is the same as two
different users editing the same record.
 
T

tony wong

i have considered to have better normalization before.

usually the database is only accessed by one user.

i made it into 2 forms because ONE screen cannot fit them all into.

i made it only 1 table because there is no one to many relation

hope to receiving your further advice.

thanks a lot.

tony
 
Top