Recent content by NYC

How about as an IIF statement in the underlying query? somefield: IIf(expr, truepart, falsepart) Datecheck: IIf (me.Date < Date(), 0, me.PrdCap)

Yep that's all it should be, try making a test query that opens a select query first. Like "Select * from DateWellPrevious" kind of thing just to see if it is really launching the query.

openquery will run whatever type of query it is. If you mean will it actually open and commit the data yes, it will.

I would think it's just DoCmd.OpenQuery "DateWellPrevious" you don't have to add the options.

Run your queries in code instead. I used to always attach this kind of sutff to command buttons on a form. Private Sub Command0_Click() DoCmd.SetWarnings False Docmd.openquery "query name" Docmd.openquery" the next query name" End Sub