Pop up form needs data from another form

**jpkeller55** · 10-23-2010, 07:03 PM

I am trying to build a inquiry function to my database where a user can post a question and other users can post replys...much like the thread concept of AccessForums.Net. I have a main form that contains the initial question and a subform that contains the replies. I would like to present a popup to the user to enter a reply. I have figured out how to do that but I need the popup form to get the value of the InquiryID from the main form and this I am having trouble with. Attached is a sample database that shows what I am trying to do.

When the POST REPLY button is selected, frmReplyEntry opens...somehow I need the Inquiry ID from frmInquiry2 to populate the InquiryID on the frmReplyEntry.

Thanks for any assistance.

**pbaldy** · 10-23-2010, 07:07 PM

Along the lines of

DoCmd.OpenForm "Whatever"
Forms!Whatever.InquiryID = Me.InquiryID

**slave138** · 10-23-2010, 07:12 PM

Set the Control Source for the field on the Reply form to:

Code:

=[Forms]![frmInquiry2]![InquiryID]

**jpkeller55** · 10-23-2010, 07:12 PM

Oh my gosh, that was too simple. I was trying to do something way to complicated. Thanks Paul!

**pbaldy** · 10-23-2010, 07:17 PM

Happy to help!

Pop up form needs data from another form

Thread Tools

Pop up form needs data from another form

Similar Threads

Filter data on a form from another control on the same form

Auto Populate a new record from a form with data from the current form

Bring data from a form to another form when an event is trigger

My form saves the data into the table, but once saved I can't see it in form view??

New form record enters data in tables, but won't show in form view

Posting Permissions