My form went blank, please help me troubleshoot... 1

[JonWolgamuth]

Friday, before I left work, I had a form developed, and which was running acceptably (more tweaks needed, but still workable). Monday morning, I opened the database and the form, and got a "recordset is not updateable" message when trying to enter sample data.

I'm not sure what happened after that, but now when I go to open the form, it gives me a blank screen (just the background color of the form shows).

Anyone have this problem before?

 

[OrWolf]

The most likely issue is that your control source is returning no records. When that happens, the blank form will appear. You need to upon up that query to find the source of the problem. Look at each piece of data in the query. Odds are that one of them is no longer being found in it's table for some reason.

 

[THoey]

I believe I have seen this if there is no data returned for the recordset. Check your tables and queries... Terry M. Hoey
th3856@txmail.sbc.com
While I don't mind e-mail messages, please post all questions in these forums for the benefit of all members.

 

[Aivars]

Check your form's recordset query (SQL clause). Maybe on the run you did create updateable query? Chech the relations between tables' fields. Try to change any data on query dialog window.

Aivars

 

[JonWolgamuth]

Thanks for everyone's help on this one. OrWolf had the correct answer and is the winner!

Thanks again!

Jon

 

[TTThio]

How about vote for him?

 

[JonWolgamuth]

Whoops. Good call...and done. One vote for OrWolf!

Thanks everyone!