Search results

Hi all, Apologies for the confusing title; I wasn't sure how to explain it succinctly. Here's what I want to do: I have a table with 3 (relevant) fields - Name, Number and ParentNumber, where ParentNumber is a value of Number on another row of the same table, and I want a form to show the...

Hi All, I have a form with a few combo boxes that will allow the user to select values and then a subform will return results that are restricted based on the user's selections (more on that in this thread...

Hi all, I have a form with a subform where there are combo boxes at the top to select one or more values and then filter the records returned on the subform based on the selected values. It uses the same logic/code as the demo in this UA post: Multi Value Fields (big thanks to theDBGuy for...

I have a data entry form with a Save button that runs a SQL insert statement. If I enter data in the form and use the record navigation buttons, the record saves without any issues but when I click the button, I get the warning that I am about to append a record, which is fine, and then I get...

I have a form that I want to use a multi-select combo box with a junction table as its control source. Let's say I have a table to store people and a table to store hobbies, and a junction table with FK_people and FK_hobby. I want to be able to enter a record for a person and select zero to...

Hello, I have a problem with combo boxes that I am hoping someone can help point me in the right direction. My Access and VBA knowledge is limited but I am very familiar with the concepts of building applications on databases (mostly Oracle). To keep it simple, I’ll use an analogy of an...