Need Help w/ recordset find

Results 1 to 2 of 2

Thread: Need Help w/ recordset find

  1. #1
    Join Date
    Dec 1969

    Default Need Help w/ recordset find

    I have 2 queries (2 recordets) one has all employees. The 2nd has just a few of the same employees (say, those with green eyes only - fictiuos of course).<BR>Now, in the page itself I move through the 1st recordset, but during this, I want to check if the employee_id in the 1st recordset equals the 2nd recordset&#039s employee_id too have a note or color or something change. Any help would be GREATLY appreciated !!! Thanks !

  2. #2
    Join Date
    Dec 1969

    Default RE: Need Help w/ recordset find

    Keep the first recordset as forward-only. The second recordset should be a scrollable one. While looping through the first recordset, use the Find method to search for the same employee_id in the second recordset. After executing the Find method, say MoveFirst because the Find method searches in the forward direction only. If the find method is successful, you can do whatever processing you want with the current record.<BR><BR>Hope this helps.<BR><BR>Cheers<BR>Santhosh

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts