Hollis,Virginia
HollisVJ at pgdp.usec.com
Thu Jan 30 09:19:01 CST 2003
No, that opens the form showing all requests that are active, it does not take into account matching the EngineerID with the Status. Va. -----Original Message----- From: Steven W. Erbach [mailto:serbach at new.rr.com] Sent: Thursday, January 30, 2003 9:08 AM To: accessd at databaseadvisors.com Subject: Re: [AccessD] Don't Want form to open Virginia, Also couldn't you change your stLinkCriteria to: stLinkCriteria = "[EngineerID]=" & Me![UserID] & " AND ([StatusID] = 1" & _ " Or [StatusID] = 2 Or [StatusID] = 4" Regards, Steve Erbach Scientific Marketing Neenah, WI "Nothing so needs reforming as other people's habits." - Mark Twain -------------- next part -------------- An HTML attachment was scrubbed... URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030130/e9d50ef2/attachment-0002.html>