Disappearing Forms...

[Dummy007]

Good Day Everyone

I am in a dilly of a pickle here: after i set up my form all nice nice, with cascading combo boxes, other random combo boxes, a search button, setting up the SQL, etc. I was so proud- thinking i've finally done it!
But then... as I reloaded the access form afterwards it only displayed in design views and SQL views, and not the other view.
So, this being my first ever database, I have no idea what the problem is.
I have checked the properties box, and it is not a problem with the settings -not - being on display always, nor with the other property settings. (I believe)

Any advice/input would be greatly appreciated into this matter
Thanks a million in advance!

~ N' Take Care ~

 

[RuralGuy]

What does this mean?

...and not the other view.

Does the screen go blank? As a test, try setting DataEntry to Yes and see what happens. You may be describing a form that has no records to display.

 

[Ron_dK]

Open the form in design view and check that the form properties "Default view" are set to single or continuous form.
Make sure you save the form with those properties set to that.

 

[ghudson]

If your SQL data source has zero records then your form will appear to be empty when you open it. Search around for there are plenty of posts on how to count the records in the data source and close the form [with a message box warning] so that the user is not stuck on an empty form.

 

[Dummy007]

Thanks so much everyone!
I was flabberghasted to find three replies to my message when I arrived the next morning at work!
You are all increadible and your suggestions invaluable.
- The problem was infact that the source of the form data (in form view - ie the 'other view' (which was quoted earlier) ) was linked to a query used for the search function.

Thanks again!

Take care all! N' have fun!