MS SQL Server ODBC - Using a form with drop down selections to populate SQL function criteria

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Using a form with drop down selections to populate SQL function criteria

Ernie

2006-10-24, 6:40 pm

I have a selection form that collects the following data with their
associated form field names:

Warehouse (Whse) This is a drop down list of appx 40 items
Part Number (PartNumber) This is a drop down list of appx 2300 items
Status (Status) This is a drop down list of appx 10 items
Start Date (StartDate) This is a manually entered date
Stop Date (StopDate) This is a manually entered date

I need to pass the selections in the above form to the criteria section
of SQL Function "VFinventory"

The corresponding function field names are the same as the form field
names.

How do I 'pass' these parameters to the function to use as criteria in
the fields? If I want ALL warehouses, I select ALL from the list. I
assume this selection would need to be converted to a '%' to pass to
the function criteria field.

Any help would be greatly appreciated.

Sponsored Links