Object Required Error Message

[purplecruz]

I have a form with subforms that people use to make orders. When the button on the switchboard is clicked to fill out a form, a new blank order form opens. I would like to make it easy for people to access previous order forms for editing. I tried doing this by creating another form where someone can enter their name, the vendor name, and the date as criteria. I then have a button to click on to open that specific order form for editing. The problem is I keep getting an "object required" error message. Here is my code:

stDocName = "frmAcquisInfo"
DoCmd.OpenForm stDocName, (tblEmployee.[Employee_Name] = Forms!frmedit!cboempname) And (tblVendor.[Vendor_Name] = Forms!frmedit!cbovendor) And (tblAcquisInfo.[Date] = Forms!frmedit!txtDate), , stLinkCriteria

Can anyone help me?

Thanks purplecruz

 

[purplecruz]

Almost

Thank you so much for the help. Sorry, I don't know very much VBA. I am much closer now, but when I click the command button I am prompted for parameter values for employee name and vendor name, but not for the date. Shouldn't it be getting those values from what the user has entered. They are combo boxes by the way. I will also change the name for date so I don't have any problems with that. Thank you for your help.

purlecruz