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

Information from one form to another

rcollins
100+
P: 234
I have three fields on my form that when I open the Add Contact form I want them to caay over. Last Name and First name are working fine because I do not need to store these in the table throuh the Add Contact form. the one I am having an issue with is ClientID. I have Control Source set as ClientID and Default Value as =[Forms]![frmContacts]![ClientID] so that it pulls the ID number from the previous form. The problem is that every time I input into one of the other fiields, it resets the ClientID to 0. Not good. Cay anyone help? Thanks
Dec 12 '07 #1
Share this Question
Share on Google+
3 Replies


NeoPa
Expert Mod 15k+
P: 31,661
A little confusing as various items are referred to without any explanation / introduction. If I can read between the lines though, I'm surprised that you're getting the field reset to zero if you have the Default Value set.
I would consider setting the Default value to the literal value (using code) whenever [Forms]![frmContacts]![ClientID] is updated.
Dec 13 '07 #2

rcollins
100+
P: 234
Thank you. I put the code when I opened the add client form. Worked great.
Dec 13 '07 #3

NeoPa
Expert Mod 15k+
P: 31,661
That's great.
I think I remember you from before. You don't need everything as well spelled out as some do as I recall.
Dec 13 '07 #4

Post your reply

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