Results 1 to 3 of 3

Thread: VBA OpenForm and RecordSource properties problem

  1. Jul 3rd, 2006, 02:09 PM #1
    PlayKid
    PlayKid is offline

    Thread Starter
    Hyperactive Member
    Join Date
    Sep 2004
    Posts
    484

    VBA OpenForm and RecordSource properties problem

    Hi all,

    I had a problem on MS Access, I tried to code with OpenForm with Where conditions to open a form, and then after some activities, I need to do a requery on the form to a specific record, so I say [Form_mainform].Recordsource = strSQL, and now, the problem comes, it throws me an unknown error. But if I tried to open the form without the where conditions, the requery works 100%.

    Please anyone help me to resolve?

    Regards

    PlayKid
    Reply With Quote Reply With Quote
  2. Jul 4th, 2006, 05:35 AM #2
    westconn1
    westconn1 is offline
    PowerPoster
    Join Date
    Dec 2004
    Posts
    25,618

    Re: VBA OpenForm and RecordSource properties problem

    post your code so we can have a look

    pete
    Reply With Quote Reply With Quote
  3. Jul 4th, 2006, 08:37 AM #3
    salvelinus
    salvelinus is offline
    Frenzied Member
    Join Date
    Feb 2003
    Location
    Argentina
    Posts
    1,950

    Re: VBA OpenForm and RecordSource properties problem

    And the error. What's an "unknown" error? It should at least give you a number.
    Tengo mas preguntas que contestas
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width