Close combo box 1

[mcginty]

Hi,

I have a form with a combo box. If I copen and close the form closes normally however if I select an option from the list box and click close button I get 'Cannot access selected table' Do I have to release the combobox?

I'm using two tables, 1 for combobox and 1 for query data, the close button releases the form and closes tables.

Ted

 

[ramani]

Check if you have anything contradictory in
1. ComboBox valid event
2. ComboBox LostFocus Event
There could be some code which contravens the situation.
ramani
(Subramanian.G)
FoxAcc
ramani_g@yahoo.com

 

[jimstarr]

Hi Ted,

If you take the code that closes the tables out of the click event of the "Close" button and put it into the destroy method of the form, I think your problem will clear up.

Jim

 

[mcginty]

Thanks ramani, I had no conflicting data, thanks Jim this worked a treat.

Rgds,
Ted

 

[DannC]

Check the Unload , LostFocus, Refresh or Requery methods either for the cboBox and the frm. Try to add data to cboBox programmaticaly width addlistitem. Anyway take a look at the enviroment prop&meth.