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/
 


Reply via email to