Thanks I already checked that.........
A.T.. --- In [email protected], "Richard" <[EMAIL PROTECTED]> wrote: > Did you add the new employee to the Employee Table first? Check > that, it sounds like that's your problem. > > HTH! > > Alienwebmaster > > > --- In [email protected], "torres0157" > <[EMAIL PROTECTED]> wrote: > > 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=12hskdnm4/M=362131.6882499.7825260.1510227/D=groups/S=1705115370:TM/Y=YAHOO/EXP=1123891836/A=2889191/R=0/SIG=10r90krvo/*http://www.thebeehive.org ">Get Bzzzy! (real tools to help you find a job) Welcome to the Sweet Life - brought to you by One Economy</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/
