Hello
Need little help on how to build a popup form. My main form (FTOpenBalanceForm)is going to have about 14 tex box. I need to add more text box (DeptName,Address)to the form but it's going to be too much in one form and these text box won’t be used as much. I would like for the user to click on PmtsentToAnotherDept from the main form and a new form (FTOpenBalanceFormPMTDeptSentTo)would pop up for the user to enter data.
I setup FTOpenBalanceFormPMTDeptSentTo form to popup. How do i link the same id from the main form to the form that popup?
Main Form(FTOpenBalanceForm)
ID BillingProviderLastName PtAcct PtProcCodeCPT PtLastName PtFirstName PtCategory SvcDateStamp SumOfCharges SumOfPayments SumOfAdjustments Balance Status Date User Comments PMTSentToAnotherDept 1414 Smith 1524 1170F Doe Sandy N/A 5/23/2014 0.01 0 0 $0.01 TRUE
Popup Form (FTOpenBalanceFormPMTDeptSentTo)
ID DeptName Address 1414 PA 1975 River st
Build a new query for the popup form (QTOpenBalanceFormPMTDeptSentTo) not sure if that is correct.
Here is a copy of the db
Database4.zip
Thank you