Unable to Requery Combo Box

C

CSDunn

Hello,
I have a combo box in a subform named 'Combo62' with a record source that
accepts a parameter (Recourd source is a SQL Server 2000 Stored Procedure.).
The record source parameter is updated with a new value when a selection is
made in a combo box in the main form.

I need for 'Combo62' to show updated information after the record source of
'Combo62' has taken a new parameter. I have tried the following on
'Combo62':

Private Sub Combo62_GotFocus()
Combo62.Requery
End Sub

This has not worked. If I hard code a parameter value into the record source
for 'Combo62' with the main form open and click 'Combo62' in the subform, I
can see that the data in 'Combo62' has not changed. If I leave the hard
coded parameter value in the procedure, then close an reopen the form, I can
see that the data then changes for 'Combo62' in the subform.

Any ideas?

Thanks for your help!

CSDunn
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

combo box issue 1
Combo Box problems 10
Combobox trouble 1
Combo Box problem 0
Requery Combo box in popup form 2
Requery combo box on a subform 3
Select item in combo box to show all records in subform 1
synchronized Combo Boxes in subforms 2

Top