Query runs fine, but doesn't show on form

S

suek

Hi, If I go to RecordSource for the form, and run the query, it populates
with all the records, but they are now not showing in the form. (they were,
but I don't know what I have done to stop it from happening) Where do I
change it to make it work again?
 
J

John W. Vinson

Hi, If I go to RecordSource for the form, and run the query, it populates
with all the records, but they are now not showing in the form. (they were,
but I don't know what I have done to stop it from happening) Where do I
change it to make it work again?
Click to expand...

Since we don't have any idea what you've done, it's a bit hard to tell you how
to undo it - but one point is that you do NOT need to "run" a query. Simply
setting a Form's RecordSource property to the name of a query, or to a SQL
string, will display the results of that query on the form. Opening the query
datasheet is neither necessary nor helpful in this regard!

If the query is showing the right records but the form is only showing one
blank record, it's likely that the form's Data Entry property has been set to
Yes. That's what Data Entry is for - let you enter new records but not see old
ones.

John W. Vinson [MVP]
 
Top