Getting table info to automatically display in a form

[Guest]

I have a table with information about a study (TStudyInfo) including StudyID#
and a checkbox that I check if the study is currently active. I would like
to make a form (FStudyCensus) that would enter census information into a
separate table (TStudyCensus) - for instance the number of subjects for the
month. I want the form to show only the active protocol number and a box
where I can enter the number of subjects. I don't know how to get the form
to ONLY display the active protocol study numbers from TStudyInfo. Can you
help?

 

[BruceM]

In general, you would make a query based on the table. Set the criteria for
the checkbox field to True. Base the form on that query. However, your
exact meaning is not quite clear, so a more precise answer is not possible.