Hello,
I have a command button on a main menu to open a form. I only want the forms opened showing the records where a particular field is null. I'm trying this code in a couple of different ways, but when I click the button, I'm always prompted for a parameter value of the LeadTech field. Here's the code...
Dim stDoc As String
Dim stCond As String
stDoc = "frmWorkOrders"
stCond = "txtLeadTech Is Null"
DoCmd.OpenForm stDoc, acNormal, , stCond, acFormEdit
I've also tried putting the condition right into the DoCmd line like this...
DoCmd.OpenForm stDoc, acNormal, , "txtLeadTech Is Null"
, acFormEdit
with the same results. Any help out there this time of night? Thanks!