Mendel
01-26-2001, 12:50 PM
I hope I can explain this ok.
I have a combo box called cboSite1 which I set the Row Source Type property to Table/Query and I set the Row Source property to a table called tbSiteSelection. When I run the form the combo box works fine and the drop down shows everything in tbSiteSelection. Now here's the catch. I have an option group with 4 option buttons which references 4 different switches(1,2,3 and 4). I wrote code for a command button called cmdPrepareSelectedSwitch which deletes tbSiteSelection and then datafills tbSiteSelection with the corresponding switch that was selected. Now when I click on the drop down combo box which should show tbSiteSelection with the new data for the selected switch, it just shows a list of #Deleted for the whole table. I'll minimize the form to go look at the actual table tbSiteSelection and the old data was cut and the new data was pasted in the table just fine, but the combo box shows the table as being deleted. How can I run the form and select the different switches and get the combo box to display the tbSiteSelection data every time?
I'm sure this all might sound confusing, but if anyone can follow this I would greatly appreciate any assistance.
I have a combo box called cboSite1 which I set the Row Source Type property to Table/Query and I set the Row Source property to a table called tbSiteSelection. When I run the form the combo box works fine and the drop down shows everything in tbSiteSelection. Now here's the catch. I have an option group with 4 option buttons which references 4 different switches(1,2,3 and 4). I wrote code for a command button called cmdPrepareSelectedSwitch which deletes tbSiteSelection and then datafills tbSiteSelection with the corresponding switch that was selected. Now when I click on the drop down combo box which should show tbSiteSelection with the new data for the selected switch, it just shows a list of #Deleted for the whole table. I'll minimize the form to go look at the actual table tbSiteSelection and the old data was cut and the new data was pasted in the table just fine, but the combo box shows the table as being deleted. How can I run the form and select the different switches and get the combo box to display the tbSiteSelection data every time?
I'm sure this all might sound confusing, but if anyone can follow this I would greatly appreciate any assistance.