Dears
I need your kind help.
I have main form "QCertDetails" including major fields as below:
Form1: QCertDetails (Main Form for Data Entry)
QCertID: AutoNumber
Product : Short Text * Combobox on form and filled from tblProducts.
PDate: Date/Time
Otherfields.
Form2: PLTDataSearch (Datasheet form view to review records only). Data supplied by a Query
TestID: AutoNumber
Product : Short Text
PDate: Date/Time
Otherfields.
Requirement-1!
I want to apply a command button on form2 (on click event) to pop up form2 based on the criteria entered in the Form1 fields "Product" & "PDate" to pull the all records matching with "Product" & "PDate".
Requirement-2!
How to append one of the record displayed on Form2 into the related fields of Form1. Lets start this later.
Kind Regards