Update record

  • Thread starter Thread starter tony wong
  • Start date Start date
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
 
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.
 
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
 
tony said:
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.
Click to expand...

Then I would recommend using a TabControl so that you can have ONE form with TWO
Tab Pages.

Your immediate problem though should be solved by issuing a Refresh to the first
Form in the Close event of the second Form.

Forms!FormName.Refresh
 
Back
Top