View specific data in a form

  • Thread starter Thread starter Dimitris Nikolakakis
  • Start date Start date
D

Dimitris Nikolakakis

I have a SP qOrders (orders of clients).

I have a form FClients and I want to create a button to execute this SP and
view the orders of the loaded client in FClients.

Any help is appreciated.

Thanks
 
Well, the easiest way would be to set the RecordSource of your form in order
to call the SP; something like:

Me.RecordSource = "exec qOrder " & Id_of_the_Client

Of course, I don't know if FClients is the form that you want to update or
if you want to open another form and use some value of FClients to filter
this second form.

There are also other possibilities for querying or filtering your forms. I
would suggest that you make some tests with the above formulation and that
you read the previous posts in this newsgroup.
 
Another option is to
-make qOrders the recordSource
-Have the button open the form and change the inputParameters to the
ClientID.

You could also
-have the top subForm contain the Clients.
(have the onCurrent event change the inputParameters of the Orders subForm)

-have a bottom subForm contain the orders.
(make the ordersSubForm.RecordSource = qOrders)

hth,
bob.
 
Back
Top