What Form Filter............

M

MRL

Could I have turned off which would result in a blank form displayed, in
tacked, with "NO" data, fueled by a working query? Did a quick test, messin'
with "Dynaset", that did it........... The whole thing worked Monday
afternoon, then I decided to tweak it. Today I blocked out some code & 4 out
of 5 forms work, the 5 is tied into my last coding drive. Oh ya......... i
flunked "PoP UP"
Thanks
 
6

'69 Camaro

Hi.
What Form Filter............Could I have turned off which
would result in a blank form displayed, in
tacked, with "NO" data, fueled by a working query?
Click to expand...

It's probably a form property, not a filter, that is preventing you from
seeing these records. Open the form in Design View and open the Properties
dialog window. Select the "Data" tab and change the Data Entry Property from
Yes to No. (If you also see a value in the Filter Property, you can probably
delete that value.)

Save the form and close the Properties dialog window. Open the form in Form
View. Now do you see the records that you should?

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address so that a message will
be forwarded to me.)
- - -
If my answer has helped you, please sign in and answer yes to the question
"Did this post answer your question?" at the bottom of the message, which
adds your question and the answers to the database of answers. Remember that
questions answered the quickest are often from those who have a history of
rewarding the contributors who have taken the time to answer questions
correctly.
 
L

Larry Linson

Since Access V. 1.0, when the RecordSource of a Form returns no records, if
the Form's Allow Additions property is not Yes, the Form will not show the
controls that would display the record, e.g., a "blank" form.

It may or may not be the best way to handle that situation, but it is the
way that Access _does_ handle it.

Could it be that somewhere in the process, you changed the Form so that it
does not allow Records to be added? Or changed the data so that this is the
first time that Form has not had data?

Larry Linson
Microsoft Access MVP
 
M

MRL

That did it!!!!!!!!!!!!! I was grasping for straw, trying anything, & must
have turned that off. Yesterday was a bad programming day!
Thanks
 
M

MRL

It was "Data Entry" I'd turn on, sounded like a good thing to do at the time,
then must of forgot all about it! Only wasted a day & a half, don't tell my
boss.
Thanks
 
6

'69 Camaro

must
have turned that off.
Click to expand...

Don't feel bad. I've done the same thing myself. And you're very welcome!

It appears that you tried to mark my reply as the answer to your question,
but Microsoft's Web portal is very buggy and it didn't recognize you as the
original poster of the question, so no green check mark appears (and your
question won't be placed in the Microsoft's knowledge base of answered
questions until there is one). Only "1 of 1 people found this post
helpful," which means someone other than the original poster of the question
marked it.

Would you please sign into the Microsoft Online Community again and make
sure that the Web portal recognizes you as the original poster (you may have
to visit your user profile or post a message first), and then navigate to
your question and try to mark my reply as an answer again? If you don't see
a green check mark appear after a few minutes and a refresh of the Web page,
then the Web portal doesn't recognize you as the original poster.

Thanks!

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.
 
Top