Pass data from a Form to another form
Hi
I have a form which I ask user for date from, date to, and Pratice. Then I want to pass them to second form which is based on a query. I want to use the items from the first form to filter the query for the second form like this
SELECT DISTINCT t1.CUST_PRACTICE, t2.CUST_NAME, t3.EMP_NAME
FROM
(
(SELECT CUSTOMER_PRACTICE.CUST_PRACTICE, TIMESHEET.TIME_DATE, TIMESHEET.TIME_ID, CUSTOMER.CUST_NAME, CUSTOMER.CUST_PRACTICE_ID
FROM (TIMESHEET
LEFT JOIN CUSTOMER ON TIMESHEET.CUST_ID = CUSTOMER.CUST_ID)
LEFT JOIN CUSTOMER_PRACTICE ON CUSTOMER.CUST_PRACTICE_ID = CUSTOMER_PRACTICE.CUST_PRACTICE_ID
WHERE ( (TIMESHEET.TIME_DATE) >=[Forms]![frmClientbyPractice].[dtFrom] AND (TIMESHEET.TIME_DATE)<=[Forms]![frmClientbyPractice].[dtTo])
AND (CUSTOMER_PRACTICE.CUST_PRACTICE=[Forms]![frmClientbyPractice].[cboTSPractice])) AS t1
LEFT JOIN
( SELECT CUSTOMER.CUST_NAME, TIMESHEET.TIME_ID
FROM TIMESHEET
LEFT JOIN CUSTOMER ON TIMESHEET.CUST_ID = CUSTOMER.CUST_ID) AS t2 ON t1.TIME_ID = t2.TIME_ID)
LEFT JOIN
( SELECT EMPLOYEE.EMP_NAME, TIMESHEET.TIME_ID
FROM (TIMESHEET
LEFT JOIN [ORDER] ON TIMESHEET.ORD_ID = ORDER.ORD_ID)
LEFT JOIN EMPLOYEE ON ORDER.ORD_PM = EMPLOYEE.EMP_ID) AS t3 ON t1.TIME_ID = t3.TIME_ID;
but the [Forms]![... items are always empty??? Please help me.
Thank you
Hi
I have a form which I ask user for date from, date to, and Pratice. Then I want to pass them to second form which is based on a query. I want to use the items from the first form to filter the query for the second form like this
SELECT DISTINCT t1.CUST_PRACTICE, t2.CUST_NAME, t3.EMP_NAME
FROM
(
(SELECT CUSTOMER_PRACTICE.CUST_PRACTICE, TIMESHEET.TIME_DATE, TIMESHEET.TIME_ID, CUSTOMER.CUST_NAME, CUSTOMER.CUST_PRACTICE_ID
FROM (TIMESHEET
LEFT JOIN CUSTOMER ON TIMESHEET.CUST_ID = CUSTOMER.CUST_ID)
LEFT JOIN CUSTOMER_PRACTICE ON CUSTOMER.CUST_PRACTICE_ID = CUSTOMER_PRACTICE.CUST_PRACTICE_ID
WHERE ( (TIMESHEET.TIME_DATE) >=[Forms]![frmClientbyPractice].[dtFrom] AND (TIMESHEET.TIME_DATE)<=[Forms]![frmClientbyPractice].[dtTo])
AND (CUSTOMER_PRACTICE.CUST_PRACTICE=[Forms]![frmClientbyPractice].[cboTSPractice])) AS t1
LEFT JOIN
( SELECT CUSTOMER.CUST_NAME, TIMESHEET.TIME_ID
FROM TIMESHEET
LEFT JOIN CUSTOMER ON TIMESHEET.CUST_ID = CUSTOMER.CUST_ID) AS t2 ON t1.TIME_ID = t2.TIME_ID)
LEFT JOIN
( SELECT EMPLOYEE.EMP_NAME, TIMESHEET.TIME_ID
FROM (TIMESHEET
LEFT JOIN [ORDER] ON TIMESHEET.ORD_ID = ORDER.ORD_ID)
LEFT JOIN EMPLOYEE ON ORDER.ORD_PM = EMPLOYEE.EMP_ID) AS t3 ON t1.TIME_ID = t3.TIME_ID;
but the [Forms]![... items are always empty??? Please help me.
Thank you