By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
426,248 Members | 1,961 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 426,248 IT Pros & Developers. It's quick & easy.

form and subform_problem when update the link field then the subform lose his data

P: 18
I have a form with a subform in access 2007.
When i edit some fields in mainform everything was ok. The problem is when i change the value of primary key field in mainform lets say (id) field, then in the subform the link field (id_subform) changes with the value of mainform (id), but all the other fields change to null vallues, so it loses the previous values. This happen only in subform, while in mainform the vallues remain with the (id) value.
Thanks in advance.
Jun 26 '12 #1
Share this Question
Share on Google+
1 Reply

P: 759
Why you need to change the value for primary key ?
Any way... try to requery the subform after you make this change.
Jun 27 '12 #2

Post your reply

Sign in to post your reply or Sign up for a free account.