[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 * 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/
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: ms_access@yahoogroups.com [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 * 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/
RE: [ms_access] ComboBox Selection for a form
As always John...worked like a charm! Thanks! Dave -Original Message- From: ms_access@yahoogroups.com [mailto:[EMAIL PROTECTED] Behalf Of John Viescas Sent: Friday, April 14, 2006 3:10 PM To: ms_access@yahoogroups.com 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: ms_access@yahoogroups.com [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/