QBF in Access 2007

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Connell
    New Member
    • Jun 2007
    • 5

    QBF in Access 2007

    Are there new guidelines for using Query by Form in Access 2007? I have not been able to construct such a QBF using the techniques that worked in prior versions. For example it won't accept date fields provided by my QBF_Form (an unbound form using an unbound text box.) When I execute the code to open a report whose query uses a criteria such as "Between Form![QBF_Form]![1st date] And Form![QBF_Form]![2nd Date], Access doesn't appear to look to the QBF form for the criteria, but always asks again for the criteria already specified in the form. Very frustrating.
    Thanks for any help.
  • sierra7
    Recognized Expert Contributor
    • Sep 2007
    • 446

    #2
    Hi
    I'm logging in to this because a number of problems seem to be attributed to 2007 and I want to keep up!

    I would comment however, that I thought the syntax was Forms! not Form! and this might be the cause of your problem

    S7

    Comment

    Working...