By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
454,105 Members | 1,040 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 454,105 IT Pros & Developers. It's quick & easy.

not show records in a form

P: n/a
hi..

have a continious form.
there are some records that i'd like to omit from showing in the form. is it
possible to set a check box that if set to true will make sure that the
record is not displayed in the form

Nov 13 '05 #1
Share this Question
Share on Google+
4 Replies


P: n/a
"mugen" wrote
have a continious form. there are some
records that i'd like to omit from showing
in the form. is it possible to set a check
box that if set to true will make sure that the
record is not displayed in the form


If you include a Yes/No field in the Table, set it for the records you
do/don't want to display, then use a Query as the RecordSource for the Form,
specifying the value of that Yes/No field that you want to display as a
Criteria, you will accomplish what you want to do.

Larry Linson
Microsoft Access MVP

Nov 13 '05 #2

P: n/a
i'm a bit unsure what you mean here.
in the criteria section of the query do i put code into this?
"Larry Linson" <bo*****@localhost.not> wrote in message
news:9CyId.3769$BL3.1172@trnddc01...
"mugen" wrote
have a continious form. there are some
records that i'd like to omit from showing
in the form. is it possible to set a check
box that if set to true will make sure that the
record is not displayed in the form


If you include a Yes/No field in the Table, set it for the records you
do/don't want to display, then use a Query as the RecordSource for the
Form,
specifying the value of that Yes/No field that you want to display as a
Criteria, you will accomplish what you want to do.

Larry Linson
Microsoft Access MVP

Nov 13 '05 #3

P: n/a
On Sat, 22 Jan 2005 23:38:35 -0000, mugen wrote:
i'm a bit unsure what you mean here.
in the criteria section of the query do i put code into this?

"Larry Linson" <bo*****@localhost.not> wrote in message
news:9CyId.3769$BL3.1172@trnddc01...
"mugen" wrote
have a continious form. there are some
records that i'd like to omit from showing
in the form. is it possible to set a check
box that if set to true will make sure that the
record is not displayed in the form


If you include a Yes/No field in the Table, set it for the records you
do/don't want to display, then use a Query as the RecordSource for the
Form,
specifying the value of that Yes/No field that you want to display as a
Criteria, you will accomplish what you want to do.

Larry Linson
Microsoft Access MVP


Set the criteria for the Yes/No field to -1 to show the records that
are checked, or 0 to show only the records that are unchecked.
--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.
Nov 13 '05 #4

P: n/a
thanks for that larry..
probably a very simple action for you, but was a major headache for me :)
"fredg" <fg******@example.invalid> wrote in message
news:13*******************************@40tude.net. ..
On Sat, 22 Jan 2005 23:38:35 -0000, mugen wrote:
i'm a bit unsure what you mean here.
in the criteria section of the query do i put code into this?

"Larry Linson" <bo*****@localhost.not> wrote in message
news:9CyId.3769$BL3.1172@trnddc01...
"mugen" wrote

have a continious form. there are some
records that i'd like to omit from showing
in the form. is it possible to set a check
box that if set to true will make sure that the
record is not displayed in the form

If you include a Yes/No field in the Table, set it for the records you
do/don't want to display, then use a Query as the RecordSource for the
Form,
specifying the value of that Yes/No field that you want to display as a
Criteria, you will accomplish what you want to do.

Larry Linson
Microsoft Access MVP


Set the criteria for the Yes/No field to -1 to show the records that
are checked, or 0 to show only the records that are unchecked.
--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.

Nov 13 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.