referencing query fields in vb

[Frank72]

Hi,

Im trying to change a value in a field (warrantyRebateBatchNbr) using a list box value
something like:

Set qryRebateReport![warrantyrebatrebatchnbr] = Me![lstDateUpTo]

any ideas on the proper syntax or am i barking up the wrong tree all together?

thanks alot

frank

 

[jgoodman00]

If you create a query, which has the criteria set to [forms]![frmName]![fieldName], it will either ask for the parameter value (if the form is not found or closed), or it will take the value contained in the referenced field & place it into the query criteria expression...

You could then call this query from code:
DoCmd.RunQuery "qryName"

James Goodman