Hi,

I have a query that adds records to a table. I need to run this query several times, each time with a specific criteria. For example, i need to run it when field1 = "A"; then I need to run it when field2 = "B"... and so on.

Now I have two questions:

1) In VB, how can I reuse the same query with a criteria instead of creating 26 queries?

2) In VB, how can I increment the criteria value ("A" to "B", to "C", etc.)

Thank you !

Chantal

Hi,

   This can be easily done. I need to know more about table structure and the query. When will these queries be done? With user input on a form, or automatically at some point according to the time of day, etc?

   To get you started, you can do this if you are passing a value from a combo box or text box to a query (I use this for 180 different parameters to make reports in a database using one query and one report):

'==========

   Dim stQueryName As String
   Dim stLink As String
   Dim stPassedValue As String

   stPassedValue = Me.YourComboOrTextBox.Value

   stLink = "[QueryParameterField] = " & "'" & stPassedValue & "'"

   stQueryName = "qryYourQueryName"
   DoCmd.Etc...
'==========

   If the user clicks a button to start this process, put this on the button's On Click event, and then it passes whatever value is in your text or combo box.

   NOTE ON COMBO BOXES: Make sure they are bound to the column that has the value you want to pass. Otherwise it will pass the PK, and not the meaningful value (Column 1 is the default). Text boxes won't be a problem.

HTH



mmcdonal