Is this how a combobox works?

[crobaseball]

I've googled this and surprisingly didn't find much about how combobox's work in general, so I'm hoping to get some verification. Basically, I'm following some other commands and unsure of why they work. I have a theory and hoping someone can verify what i think to be true, is, in fact, true.

A combox serves as a dropdown box to select information (I've got that much, lol). It is based on a field which is based on the record source. In this particular case, my record source is a query (an important point), and the field I've turned into a combobox is the field used to join my two tables. If I then change the row source to the actual table the rest of the data is pulling from, rather than updating a record, changing the value in the combobox instead pulls up the information which is connected in the one to many relationship. In essence, by choosing the field carefully to create the combobox, and then changing the row source information to the actual table, I can pull up the record information for the other fields in the form.



What this is akin to (in my user mind), is essentially using the combobox as a filter. I select the value, and the rest of the information in the remaining fields populates.

Is this correct? Are there any other critical points which I need to understand and use properly?

[crobaseball]

Ok, I think I was wrong. It actually does change the record, it just selects multiple values to change. Like I said, I've tried to get a general sense of how a combobox works, and most specifically, I'd like to act like a user selected filter. Does this exist or do I need to program it in VBA?

[trevor40]

very basic - combobox - bound it updates the underlying field or unbound used as a way to select a value for later use. bound or not it can have a list to choose from this comes from several possible sources, field list, value list...
to use as filter for the form the form query needs this in the criteria
after update
requery the form for filtered results

[June7]

Sounds like you have good understanding.

A combobox is used to select a value from a list. The combobox input can be restricted to items in the list or can allow any typed input. The selected item will be saved to record if the combobox is bound. If the combobox is not bound the selected item can be used for some other purpose, such as filter criteria.