As always John...worked like a charm! Thanks! Dave -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] Behalf Of John Viescas Sent: Friday, April 14, 2006 3:10 PM To: [email protected] Subject: RE: [ms_access] ComboBox Selection for a form
Dave- Try: MyWorkOrder.FindFirst "[WorkOrderID] LIKE '*" & Me.qWorkOrderNumber & "*'" Or: MyWorkOrder.FindFirst "[WorkOrderID] = " & Me.qWorkOrderNumber John Viescas, author Building Microsoft Access Applications Microsoft Office Access 2003 Inside Out Running Microsoft Access 2000 SQL Queries for Mere Mortals http://www.viescas.com/ (Paris, France) For the inside scoop on Access 2007, see: http://blogs.msdn.com/access/ -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Dave Moreau Sent: Friday, April 14, 2006 9:26 PM To: Access Newsgroup (E-mail) Subject: [ms_access] ComboBox Selection for a form What is wrong with this code...trying to set up a selection Combo Box for a form. I keep getting an error stating it is missing an operator? Thanks! Private Sub qWorkOrderNumber_AfterUpdate() Dim MyWorkOrder As DAO.Recordset Set MyWorkOrder = Me.RecordsetClone MyWorkOrder.FindFirst "[WorkOrderID] = *" & Me.qWorkOrderNumber & "*" If MyWorkOrder.NoMatch Then MsgBox "Work Order ID Not Found. Try Again." Else Me.Bookmark = MyWorkOrder.Bookmark End If End Sub This e-mail and any attachments may be confidential or legally privileged. If you receive this message in error or are not the intended recipient, you should destroy the e-mail message and any attachments or copies, and you are prohibited from retaining, distributing, disclosing or using any information contained herein. Please inform us of the erroneous delivery by return e-mail. Thank you for your cooperation. [Non-text portions of this message have been removed] Yahoo! Groups Links _____ YAHOO! GROUPS LINKS * Visit your group " ms_access <http://groups.yahoo.com/group/ms_access> " on the web. * To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> * Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service <http://docs.yahoo.com/info/terms/> . _____ [Non-text portions of this message have been removed] Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/ms_access/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
