I have a form that has been running perfectly. Its recordsource was a table. I now changed the recordsource to a query based on that table with exactly the same fieldnames etc. but it opens blank, not just empty textboxes etc but no labels and no sight of any textboxes. the funny thing is that as soon as i change the recordset type -makes no difference to what- then everything appears. however if I save it like that then it still opens blank until I change the recordset yet again
Whats going on?
Thanks

In the query underlying your form you likely have the Unique Values setting = "Yes" (produces "SELECT DISTINCT..." in the SQL for the query).

If you change the setting to "No", you should be able to see the controls on your form.