Form went blank - don't know why???

  • Thread starter Thread starter disneygoof via AccessMonster.com
  • Start date Start date
D

disneygoof via AccessMonster.com

This one is real perplexing....

I have read a number of threads related to this issue and from what I can
gather, my form is set correctly...ALLOWS are all Yes, data does exist in the
Tables, VISIBLES are all Yes. I have been working with this form for months
and not having any issues...

Form = frmBlogProjects
Subform = frmBlogProjectSubform

Form function:
The form opens with no data selected (intential) the user chooses a project
No from a combobox and the form/subform populate...this has been working for
months!!!

Here's what happened...

I created an Update Query to take a dollar amount from this forms table
(tblBlog.COAmount) and place it in another table (tblCost.COAmt). I ran the
query...now when I open the form (frmBlogProjects) I get nothing...heres the
weird part....

When I right click and clear all filters/sorts, I can see everything, but
It's still not exactly right becasue all the records are showing, not the
filtered records...as described above in Form Function.

Any thoughts?
David
 
To all,

I have determined the error here. I spend a number of hours last night
debugging my code and the issue was with the relationship between the two
tables I used in the query builder for the form. I eliminated the one table
that seemed to be causing the issue and everything is working as it was
before...I am not sure exactly WHY this was working and stopped, but until I
have another issue, I'll take it.

I love Access...it's never dull...always keeps you thinking...AWESOME!
Have a glorious day all,
David
 
Back
Top