Results 1 to 4 of 4
  1. #1
    Join Date
    Feb 2004
    Posts
    2

    Unhappy Unanswered: Parametrized Query

    I'm trying to execute a parametrized query. The parameter comes from a Text Box (TxtComapny) from the Form ( FrmContact ).

    The query Criteria is : Forms![FrmContact]![TxtComapny]
    For the parameter i've tried : Forms![FrmContact]![TxtComapny] and Forms!FrmContact!TxtCompany

    Each time Access adds automatically some "[" and "]" and pops-up an Error 3126.

    Please help !!

  2. #2
    Join Date
    Feb 2004
    Posts
    199
    Let Access add "[" & "]" , its better (to prevent objects name problems).
    write down full text of the error message.

  3. #3
    Join Date
    Feb 2004
    Posts
    2
    The full text error is ( it's a triduction from french ) :

    In square brackets syntax invalid for the Name [Forms]![FrmContact]![TxtCompany]

  4. #4
    Join Date
    Feb 2004
    Posts
    199
    Can't figure out your problem, write down SQL text that gives the error.
    I mean Parameterd Query SQL text

Posting Permissions

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