Form not working

[Sean25]

I have aform that will not pull data regardless of whether the data source is set as the Table containg the data, or as a Query. All field names match in Table/Query and the Datasources of the fields on the form.

I have another form that is set up identically (as it pertains to data, etc., not style-wise) that pulls data from both it's source table AND a query, when the data source is manipulated.

The table that the trouble form is trying to pull from opens no problem ans contains the necessary data. As well, when the query is run on its own, it works flawlessly. I am liley missing something very simple, a I just haven't worked with Access in quite awhile, but does anyone have any ideas?

 

[WayneRyan]

Sean,

If you bind your form to a table ... and still don't retrieve any
data.

1) There is not data!

2) The form's Data Entry property is set to "Yes" and can
only input new records, not display old ones.

Wayne

 

[Sean25]

I knew...

I knew it was something stupid.

I figured if i set that to "no", they wouldn't be able to edit things they were looking up in that form, and they need to be able to do that. The other form that is working is a static lookup, so that was set to "no" regarless, because the data will not be manipulated.

That's what having a server crash and loosing your application 5 years after creating it (and hardly doing any work on it, programatically) will do to you.

Thanks a lot.


S.