I IanT Registered User. Local time Today, 20:02 Joined Nov 30, 2001 Messages 191 May 29, 2007 #1 I use a form to select the perameters for data to be exported a to an excel sheet. Is it possible to export the dates selected on the form text boxs to a worksheet as well.
I use a form to select the perameters for data to be exported a to an excel sheet. Is it possible to export the dates selected on the form text boxs to a worksheet as well.
Dennisk AWF VIP Local time Today, 20:02 Joined Jul 22, 2004 Messages 1,649 May 29, 2007 #2 yes you can refer to a control on a form as if it where a value. in the field cell of a query you can do this yourValue:Forms!YourFormName!YourControl use this query to transfer the data to excel
yes you can refer to a control on a form as if it where a value. in the field cell of a query you can do this yourValue:Forms!YourFormName!YourControl use this query to transfer the data to excel
