Search results

That looks logical. So I assume that I could substitute the code you have: .txtSubjectF2 = me.txtSubjectF1 .txtMessageF2 = me.txtMessageF1 with ContactID/OrderID or whatever I wanted to pass?

Hi again, Thanks for taking the time to respond again. Apologies if I wasn't clear enough in my original question - I am a new access user so I really want to understand the underlying methodology for passing data between tables. Let me try to explain the thinking behind what I want my...

That's a very kind offer. I will see if I can do that tomorrow morning.

Hi, Thanks once again. Is the OpenArgs method suitable for use where I wish to pass more than one piece of data to the new table? Best wishes, Pete

Thank you once again for taking the time to reply - I'll take a look through the links you've shared and report back with any further questions. Have a good weekend. Pete

Many thanks for your quick response. To clarify what I'm trying to do, I think I need to give a bit more info. The subform is to give me an overview of the opportunities raised by a contact, so as such does not contain all the fields within the opportunity table - I've put control buttons...

Hi, Sorry, yes I mean subform - that's a bit of a red herring though - essentially I just want understand how I can select a contact from one table and using a button control, copy that contactID through to a new form (opportunity). The tables are linked already via contactID in the database...

Hi, I'm afraid it contains confidential information, so I'm unable to do that. Pete

Hi all, I know lots of people have had similar questions, but I've been unable to find a solution that works in my instance, so please be gentle! I'm developing a database in Access 2016. I have a form called frmContacts, which contains contact info (plus a sub-table with a snapshot view of...