i dont know if anyone else has this problem, it makes no sense to me.
on some forms i make and open them up for use and the entire form is empty no conrols or anything. just a big empty grey box. If i click the apply filter button then the controls show up, everything turns into a list box, its useless.
did anyone else have this problem? its very stressful
Originally posted by y2kmental
well this form is populated with two input boxes, from a query.
Its a real simple form, I hate this problem
There's probably something wrong with the query. Sometimes access will simply not show the controls on a form instead of giving an error message when there's a problem with the query specified in the record source.
If a form's recordsource is a query that isn't updateable and doesn't return any results, all the controls on the form will be invisible.
The key problem seems to be "no results," and although Access provides a way to detect and deal with this situation, it's very lame... But it's even worse for reports, where with some versions of the system, Access simply "locks up" more often than not.
In my case, a query is usually looking for data that is not there or is incomplete.
Forget the ADO and DAO stuff. I think mrwiggley23 was correct when he said that you have to make sure all the data is present in the underlying tables that your query is looking for.
Again, that has been my experience with this issue. A query is expecting to find a piece of data that is not there. I would carefully step throught my query to isolate the problem. If you have to, break it down into several parts.