I have a form with an unbound combo box to pull up specific records. It uses a Select query line in the form's record source and a requery on the After Update event of the combo box and the On Open event of the form.
I have also been playing with a toggle button on said form that puts a "bookmark" on a specific record so that the user can come back to it later. The bookmark has some functions, all of which work, and a record source for the form that points to the underlying table.
Both the above work on their own, independently - ie, if the record source for the form has the particular select command, I am able to have the combo box functionality; if the record source has the table name, I am able to have the toggle button bookmark functionality.
I wish to give both functionalities to the user. How do I accomplish this?