Ahem. It is difficult to sort through ranting to get at the meat of your posting. So here are just a few comments.

1. Yes, indeed, sometimes Access is a fine solution to a problem.

2. A combo box can look up a record in a table other than the same table to which your form's controls are bound in order to fill in a field in the main table. For example, a combo box could assign a customer code to a customerID field in an order record.

3. A combobox could be used to let a user find a customer order to review. Once it is selected, your controls would display the order information if they are bound to the table fields with a simple thisform.refresh().

4. The valid is a fine place to update your other controls based on the selection for the combobox. A combo box can be populated with multiple columns of information. A column can be set to zero width so the user doesn't see, but the data is still available for you (the programmer) to use by using this.list(this.listindex, n)
where "n" is the column containing the info you want.

5. I do not decide that quantum mechanics is invalid because I find it difficult to comprehend. < s(ardonic)g > )