Add Checklist - Checklists in Microsoft Access


	Back to Checklists Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Add Checklist

Ramona Woitas

4 years ago

So on the Main Menu I added a button to add a new checklist that opens the MasterListT. I've tried but I can't figure out how or where - To requery the list box after changes have been made to the table. Of course it works if you close the main menu, but ....

	Kevin Robertson @Reply 4 years ago
I would either create a form to add the new record and use the close event to Requery the List Box OR Use an Input Box and an SQL statement (INSERT INTO) to add the record to the table then Requery the List Box. If you must work directly with the Table (not recommended) Requery the List Box in the On Got Focus event of the button. To Requery the List Box: `Forms!FormName!ListBoxName.Requery`

	Ramona Woitas OP @Reply 4 years ago
Thank you Kevin! You Rock! I had the right syntax, but in the wrong place. You mentioned Not Recommended with Table, can I ask why. Is this still okay if I am the only using the database? Or will this wreck something that is currently working in the future?

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Checklists.

Next Unseen

New Feature: Comment Live View