Pulll data from another form and write it to a second form's table

[sleake]

I have a form to enter data on "Partners" with fields for partner name and partner ID. I have a separate Contacts form opened by clicking a button that links "PartnerID" on both forms. I would like to fill in the Partner Name and Partner ID on the Contacts form so the user will not have to select the Partner Name from a combo box on the form. But I need to have this information written to the Contacts table.



I can get the partner name to display, but not to write to the contacts table: =[Forms]![frm_SFTP_Add_Partner_Profile]![txtSFTPPartnerName], but this is unbound. The Partners form will be open, because it's the only access point to Contacts.

[AlexHedley]

You will need it to be bound to the table you want it adding to.

[sleake]

I guess what I'm asking is whether there is a way, other than a user action, that can enter a value into a bound control from another form?

[pbaldy]

Sure:

Forms!TargetForm.ControlName = Forms!SourceForm.ControlName

[sleake]

Thanks for your response. I have this structured with the correct form/control names. First I put it in the Target forms' control source, but received an error. Then I figured out that the control had to be bound, so I changed the source to the field name. Thinking that it needs to be in the Target Forms' events, I tried putting it into the Target Form's On Load and On Current events. (The Target may not be open when the Source forms' After Update event occurs., which I also considered.) Got message that there is an application-defined or object-defned error. As you can see, I'm feeling my way here. Any suggestions?

[pbaldy]

Sorry, that was intended to be VBA code after the line opening the second form.

[sleake]

Well, I got it to work in the Current event of the target form. (all morning! Many name errors) It writes to the table like I wanted. Putting it after the open form line in the button's code generated the same application-defined or object-defned error. So if you say it's OK if it works in the Current event, I not going to fix what's not broken.

I've been getting lots of errror since I installed 2010 on Saturday, that I'm pulling my hair out! Recompile, recompile, recompile. Now I have one last one with Alan Browne's audit routine that was working before -- something about the object has been renamed or doesn't exist in the Begin audit line, so tht's my next project for the day. I may have to post on that one too. I've check and rechecked table structure and names to no avail so far. Maybe I'll decompile and then recompile to see if that fixes the problem.

Thank you so much for your help.

[pbaldy]

Glad you got it sorted out.