Why will my data not pull through to an Access form?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have built a form in Access and a SQL query has been built as the source
for the form's data.

When I go into the Properties of the form in Design view and open the source
query, I am able to run it no problem as a stand-alone and retrieve the
relevant data. However, when I switch to Form view of the form, no data is
being pulled through and the form appears blank.

Please can someone help?
Thanks
Dave
 
On Tue, 13 Jun 2006 07:11:03 -0700, Dave Mc <Dave
I have built a form in Access and a SQL query has been built as the source
for the form's data.

When I go into the Properties of the form in Design view and open the source
query, I am able to run it no problem as a stand-alone and retrieve the
relevant data. However, when I switch to Form view of the form, no data is
being pulled through and the form appears blank.

Please can someone help?
Thanks
Dave
Click to expand...

We'll be glad to do so, if you'll help us.

Please open the query in SQL view and post the SQL text here. There is
evidently something wrong, but since we cannot see your database, it's
hard to tell what!

Also check the Allow Updates and Data Entry properties of the Form.
They should be True and False respectively if you want to see and edit
existing data.

John W. Vinson[MVP]
 
Also check, when in design view for the form, is there a specific field
name in the source for every field on the form (When looking at the
form, none of them say "Unbound").

Ron
 
Back
Top