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

Subform not keeping default values

P: 234
I have a form where I input a clients name. In the subform, I enter all of the personal information. After inserting Names, as soon as the subform is current, all of the default values go blank. How can I keep these active?
Mar 12 '07 #1
Share this Question
Share on Google+
1 Reply

Expert Mod 15k+
P: 31,349
It's hard to give an answer that you'll understand with such paucity of information provided as I can't refer to anything specifically.
In concept though, you will need to add some code into your subform that caches the data that you don't want lost (or you want to act as a default for the next Name). In the OnCurrent event procedure you'll need to check that it's a new record, then if it is, fill the controls with the previously cached data. The data would need to be cached on the subform's Form_AfterUpdate() event procedure.
Mar 13 '07 #2

Post your reply

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