maggiemel
Posts: 75
|
| Posted: 07/11/2005, 1:55 PM |
|
I'm using several listboxes on one of my record forms, which is used to keep info on real estate properties. I have a listbox for "States" and use the "many-to-many listbox" example so that properties that cover more than one state can be added/updated with a multiple selection in the listbox (works great). I would like to use this same method to add/update lenders and their respective counsel for each property. But I'm unsure of how to adapt the example for two separate listboxes when the data comes from two columns in the same table.
So, my first question is: can this example be made to work if there is more than one multi-select listbox in the record form?
My second question is: how can I adapt the example when I need to pull two columns from the lenders/counsel table, then populate two separate listboxes with the resulting recordset? I've included my SQL statement below, for illustration:
Set LendersRS = NewConnection.Execute("SELECT Lender, Counsel FROM OpinionLenders WHERE FK_OpinionID=" & NewConnection.ToSQL(CCGetFromGet("OpinionID", "0"), ccsInteger))
Thanks in advance for any assistance!
_________________
Melissa Cahill
http://www.hellcatmaggie.net/ |
 |
 |
|
