Parameter from Combo box

[Dimitris Nikolakakis]

I have a form (FactoriesOrders )with a ComboBox and a subform (FOrders) that
show the results of an SP.

The SP has a parameter and I have connected the parameter with the ComboBox
@parameter nvarchar(15) = Forms!FactoriesOrders.ComboBox

How can I refresh tha data of subform each time I change value to ComboBox?

Thanks

 

[Nikos Yannacopoulos]

Dimitri,

Try this line of code:

Me.FOrders.Requery

in the combo's On Change event.

HTH,
Nikos

 

[Vadim Rapp]

Hello Dimitris,
You wrote in conference microsoft.public.access.adp.sqlserver on Wed, 19
Jul 2006 12:11:08 +0300:

DN> I have a form (FactoriesOrders )with a ComboBox and a subform (FOrders)
DN> that show the results of an SP.

DN> The SP has a parameter and I have connected the parameter with the
DN> ComboBox @parameter nvarchar(15) = Forms!FactoriesOrders.ComboBox

DN> How can I refresh tha data of subform each time I change value to
DN> ComboBox?

Name your combobox Parameter (i.e. same as parameter of your s.p. less @)


Vadim Rapp