Check Box on the form

[Guest]

I have a CheckBox [Active] on the form. The form is powered by a table. I
would like the records that are False, not checked, not to appear on the form
or disabled. Is it possible without doing a query?
New to it, but it is slowly sinking in.
Thanks,
JPol

 

[Larry Linson]

I have a CheckBox [Active] on the form. The form is powered by a table. I
would like the records that are False, not checked, not to appear on the
form
or disabled. Is it possible without doing a query?
New to it, but it is slowly sinking in.

What do you have against Queries? That is exactly what you should use to
retrieve and display only a subset of Records.

Instead of using the Table as RecordSource of the Form, use a Query. Create
the Query by clicking on the Queries tab in the Database Window, then
clicking New. Add the Table to the Query (as a data source). Then, drag from
the Table displayed in the top area down to the grid all the Fields of
interest. (If you want all the Fields, a quick way is to double-click which
will highlight them all and you can pull them all down at once.) Under the
Yes/No Field that you are displaying in the Check Box, in the Criteria:
line, type True. That will return only those records for which the Field is
true.

It's a lot more trouble to write it out than it is to actually do what the
previous paragraph says.

Larry

 

[Guest]

Larry, nothig against query. Just a question.
Thanks,
JPol

I have a CheckBox [Active] on the form. The form is powered by a table. I
would like the records that are False, not checked, not to appear on the
form
or disabled. Is it possible without doing a query?
New to it, but it is slowly sinking in.

What do you have against Queries? That is exactly what you should use to
retrieve and display only a subset of Records.

Instead of using the Table as RecordSource of the Form, use a Query. Create
the Query by clicking on the Queries tab in the Database Window, then
clicking New. Add the Table to the Query (as a data source). Then, drag from
the Table displayed in the top area down to the grid all the Fields of
interest. (If you want all the Fields, a quick way is to double-click which
will highlight them all and you can pull them all down at once.) Under the
Yes/No Field that you are displaying in the Check Box, in the Criteria:
line, type True. That will return only those records for which the Field is
true.

It's a lot more trouble to write it out than it is to actually do what the
previous paragraph says.

Larry

 

[Guest]

Oh, one more question. I have a form with the subform, where dataset is taken
from two tables join one to many, and there are many codes written for the
pop-up calendar, and other fields, then how hard would be to use this form
with the query. Is there an easy way to make a switch without loosing the
form format?
Thanks,
JPol

I have a CheckBox [Active] on the form. The form is powered by a table. I
would like the records that are False, not checked, not to appear on the
form
or disabled. Is it possible without doing a query?
New to it, but it is slowly sinking in.

What do you have against Queries? That is exactly what you should use to
retrieve and display only a subset of Records.

Instead of using the Table as RecordSource of the Form, use a Query. Create
the Query by clicking on the Queries tab in the Database Window, then
clicking New. Add the Table to the Query (as a data source). Then, drag from
the Table displayed in the top area down to the grid all the Fields of
interest. (If you want all the Fields, a quick way is to double-click which
will highlight them all and you can pull them all down at once.) Under the
Yes/No Field that you are displaying in the Check Box, in the Criteria:
line, type True. That will return only those records for which the Field is
true.

It's a lot more trouble to write it out than it is to actually do what the
previous paragraph says.

Larry