Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Form Assistance

Status
Not open for further replies.

dbero

Technical User
Mar 31, 2005
109
US
Hello:

I am trying to create a form that displays a variable count of records. What I want to display is a text box and check box for each record that is returned. So, at times the form may display 0 records, or it may display 100.

The purpose of this form is to display all incomplete records. Then the user checks the box next to the customer when the item is completed. so the form displays all incomplete items, and allows for it to be checked by the user as complete.

Thank you very much!
 
You would have to add a Yes/No field to your table to capture the value when the user Checks the box. Then you could use a continuous form and display only those records where the Yes/No field = False or 0. If you created a continuous form without the field in your table, adding an unbound checkbox to the detail area would not work, checking it for one record would end up checking it for all records.

PaulF
 
Thank you. I will do some research on continuous forms as I have never worked with them.

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top