My ContactF - which shows people and their positions within the relevant CustomerF e.g Esme Cole - Sales Manager, Keith Cole - Property Manager etc
and then I have my CommunicationF - which reports all communication between myself and the 'Customer'.
What I have done, is added both a customerID field AND a ContactID field to my Communications form - so I can not only see the customer I'm communicating with, but also, who, within that Company I spoke to.
So, I have combo boxes set up on the Communications Form. I have also added a button to my 'ContactF'. My ContactF has both the Contacts details, as well as the Company they work for (CustomerIDCombo)
When I click on the 'add new communication button from this form, I would like the communication combo boxes for CustomerID and ContactID to automatically populate, based on the ContactF I have clicked from.
I hope that makes sense.
Reply from Richard Rost:
OK... see you've named your "ContactF" something completely different than I did, which is why I was confused.
All you should have to do is set the Default Value properties for the two ID fields on your CommunicationF form to the ID values on the other form:
=Forms!CustomerF!CustomerID
If the ContactF is a subform on the CustomerF then that would be
=Forms!CustomerF!ContactF.Form!ContactID
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Access Expert 11.