I have two different databases. Im successfully pulling data from DB1 into DB2 by this vba code:
Q1 = Nz(DLookup("[q1]", "order", "[SalesOrderNo] = Form![DOCKET]"), 0)
where Q1 is field in DB2 that is automatically filled when DOCKEt field is filled in DB2. It matches the DOCKET field in DB2...