VB Help

[superred]

I am currently writing a database application program, where I am using a drop down Combobox as a central reference to obtain information from three differing tables and several fields from a number of recordsets within each table.

I have a problem where, upon runtime, I can use the combo to obtain the first lot of search information, but the next time I use the combobox, I have a runtime error 3426, with the message "This action was cancelled by an associated program".

 

[LeighDreyer]

How are you populating the combo box ? it is possible if you are using refresh methods that this may cause the combo box to create a large stack of information to be pulled from the database causing it to crash not sure but could be the problem ?.

 

[superred]

No I am not using refresh methods, any other ideas?

 

[superred]

I am utilising the child form to obtain data from a field within a recordset of a table with the use of a drop down combobox. This field could be a different field each time, thus the combobox could be loaded with differing field information each time.

I am encountering two problems:

1) When opening a child form from the main form, the child form will not close to go back to the main form after pressing a command button and as such, continues a looping cycle between the child and main forms.
2) The combobox does not clear after each collection of field data from the differing record sets.

 

[johnwm]

ComboBox.Clear
________________________________________________________________
If you want to get the best response to a question, please check out FAQ222-2244 first

'People who live in windowed environments shouldn't cast pointers.'