Good Morning
I have a form that uses Dlookup 6 times so the user
see's which employee is assigned to a sale. The lookup displays
the Employee name, ssn, location and type.
I inserted the lookup code in afterupdate in the Name property (Combo).
all worked fine, but when I added a 7 employee on the form
I got an Error Msg
'Complie Error' Method of data member not found (error 461).
The message states I may have mispelled the object name or
I specified a collection index that's out of range and check
the count property.
Private Sub Combo299_AfterUpdate()
SSN7 = Me.Combo299.Column(0)
Me.AM7_Name = DLookup("AM_Name", "Tbl_AccountManager", "AM_SSNumber=
[SSN7]")
End Sub
Can someone tell me how many Dlookup's can I use on a Form
or/and what other code do I need to insert. May reset the count
property.
Thanks A.T.
------------------------ Yahoo! Groups Sponsor --------------------~-->
<font face=arial size=-1><a
href="http://us.ard.yahoo.com/SIG=12h60gp3h/M=362329.6886308.7839368.1510227/D=groups/S=1705115370:TM/Y=YAHOO/EXP=1123870908/A=2894321/R=0/SIG=11dvsfulr/*http://youthnoise.com/page.php?page_id=1992
">Fair play? Video games influencing politics. Click and talk back!</a>.</font>
--------------------------------------------------------------------~->
Please zip all files prior to uploading to Files section.
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/AccessDevelopers/
<*> 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/
