VBscript

[mixedguy]

Hi how would I pass a criteria value directly to a query just using VB Sript.
On my form I have 2 combo boxes and I want to pass the values directly to a query that then generates my report.

Thanks in advance!

 

[ghudson]

The easiest way to do it is to set the criteria of each field in your query to the combo boxes in your form. Here is what the criteria should look like...

[Forms]![FormName]![ComboBoxName]

Use the "Build" option in the criteria field of your query to "find" the combo box in your form.

HTH

 

[Pat Hartman]

mixedguy, FYI, there are three different versions of the VB language - VB, VBA, and VB Script. Office components such as Access, include support for VBA (Visual Basic for Applications). VB is a stand alone development environment capable of producing executable files. VB script is a "super" batch file language and is interpreted rather than compiled.