Form and Stored Procedure?

[Carlos]

Form based on Stored Procedure where AccountCode = @ActCod.
There are multiple entries with one AccountCode and I want
to display a specified entry based on the id. That is,
when the account is added/edited with say id 20398, I will
refresh the screen (this will display record with id = 1).
At this point, I want to know what to do to automatically
display record 20398.

Help is greatly appreciated.

Charles

 

[Vadim Rapp]

Hello Carlos:
You wrote in conference microsoft.public.access.adp.sqlserver on Wed, 10
Mar 2004 11:42:09 -0800:

C> Form based on Stored Procedure where AccountCode = @ActCod.
C> There are multiple entries with one AccountCode and I want
C> to display a specified entry based on the id. That is,
C> when the account is added/edited with say id 20398, I will
C> refresh the screen (this will display record with id = 1).
C> At this point, I want to know what to do to automatically
C> display record 20398.

one of the ways:

Dim rs As Recordset, BM as variant
Set rs = RecordsetClone
rs.Filter = "id=20398""
Bm = RecordsetClone.Bookmark
rs.Filter = ""
Bookmark =bm

Vadim

 

[Carlos]

Thanks man, I'm going to try it.

-----Original Message-----
Hello Carlos:
You wrote in conference

microsoft.public.access.adp.sqlserver on Wed, 10