I created a form from an existing dbquery. Why do no
records display when I open the form? I have to do a sort
to get an output.
Well, presumably you did something wrong. It's hard to say what that
might have been since you don't tell use much about what you did! Some
things to check:
- If you open the query as a Datasheet do you see the expected
records?
- What's the Form's DataEntry property? (It should be False; setting
it to True conceals existing records and puts you on the "new"
record).
- What does "opening a form" have to do with "doing a sort"? Typically
you would sort data using an Order By clause in the query.
John W. Vinson[MVP]
(no longer chatting for now)
