Where Condition

[NISMOJim]

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!

[Bob Fitz]

Perhaps:
DoCmd.OpenForm stDoc, acNormal, , "txtLeadTech" Is Null
EDIT
Please disregard the line above.
DoCmd.OpenForm stDoc, acNormal, , "txtLeadTech Is Null", acFormEdit
should work, if it doesn't work for you, can you tell us what happens when you try to use it.

[June7]

Is the name of the field txtLeadTech or LeadTech?

[NISMOJim]

The field name is txtLeadTech. It is actually a combobox with a Value List as the row source if that matters, and the Limit to List is No. When I click the command button on the menu, I get a parameters window that opens wanting me to enter the value for txtLeadTech. The query that the form is based on opens without a prompt, but it shows all work orders rather than just the ones that haven't been signed off yet by the lead tech.

[NISMOJim]

I understand now June, my incorrect terminology messed me up! The combobox on the form is named txtLeadTech but the field in the query is just LeadTech. I changed the code to get rid of the txt part and it's now working right. Thank you both for your help.