how do I run a query based on current form fields and then place the result back in the form
L LJMccuiston Aug 17, 2005 #1 how do I run a query based on current form fields and then place the result back in the form
W Wayne Morgan Aug 17, 2005 #2 Try a DLookup() function in a calculated textbox. You can use more than one WHERE parameter by linking them with And or Or.
Try a DLookup() function in a calculated textbox. You can use more than one WHERE parameter by linking them with And or Or.