I'm using a combo box, populated by a query, to filter records on a form. Is it possible to add an entry to the combo box which will select all records?
"Select 0, "All" from YourTable Union Select Field1, Field2 From YourTable.
That's the basic version. The number of columns need to match between the literals that you enter and the rest of the data that you want to display. You will have to add code to grab all of whatever it is you are displaying if the selection is 0.
I am curious how you get records to be populated on a form and its subforms based on the combo box selection?
I have a form with a sub-form. The combo box on the main form is a key field and I'd like to have the user be able to select the particular record (on the Main form) for edit purposes. At the moment, I can get the main/sf to populate using the record selector, but not the combo.
My purpose in this is to enable the form for both new record entry as well as edit of existing records. If I can get it to achieve the simple form scenario described above, I'd like to use the same functionality for more complex forms/sfs that I have. I am just learning VB.