Recordset filter

Results 1 to 2 of 2

Thread: Recordset filter

  1. #1
    Join Date
    Dec 1969

    Default Recordset filter

    I&#039;m joining two tables and the I want to do a recordset filter. It doesn&#039;t work!! Can anybody tell me what should I do?<BR>My tables are "ea" and "la".<BR>Is this wrong? - <BR>objRs.Filter = " ea.Agent_Type = 0"<BR><BR>I think I&#039;m doing everything alright unless it&#039;s impossible to do a RS.Filter when joining tables!!!<BR>Any help would be very much appreciated.<BR><BR>Thanks

  2. #2
    Join Date
    Dec 1969

    Default RE: Recordset filter

    That looks pretty much OK to me. I don&#039;t think you need the space before ea.Agent_Type though.<BR><BR>Do you get an error message? Is ea.Agent_Type a field in the original recordset?

Posting Permissions

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