Search results for query: *

OK, great. Thanks a bunch!

I have done all my controls in the form with recordsets and being unbound, since so far I am accessing six different tables. I'm not sure how to add a bound control in the middle of that. I am populating the controls from the recordsets on update from initial search combo box, then after...

Is is possible to have a combo box on a form that shows the value saved in the table matching the selected record, as well as providing the other possible values in that table in the drop-down for changing the selection for that record? I have a multi-table form and would like to be able to view...

No, the form name is still Form1.

Yes, I see the point of using 2 boxes; I thought maybe when bringing the record up later, the ones NOT previously selected could be grayed out. But 2 boxes is fine. Can you tell why when opening the form, a box appears asking for user to "Enter parameter value: Forms!frmForm1!Prov_ID"? What...

Thanks both of you for the help! With Lonnie's code it saves the selections to the child db. There is a glitch however when opening the form. A box appears asking for user to enter parameter value: Forms!frmForm1!Prov_ID. If I enter a number so it will open the form (which I shouldn't have...

I have 2 tables: parent table= tblListProv and child = tblCriteria. tblCriteria needs to store multi-selections linked by Prov_ID to tblListProv from a listbox (lboCriteria) that I placed on frmForm1. I can select more than one item from the listbox (using simple property) but how do I save...