stored procedure adp-fil

You have to use some VBA to execute the sp.

When you sacan and enter I think this will fire a lost focus event so put the code there.


Some think like this (not tested)

Dim cmd as ADODB.Command
Set cmd = New ADODB.Command

cmd.ActiveConnection = CurrentProject.Connection
cmd.CommandType = adCmdStoredProc
cmd.CommandText "NameOfSP"

cmd.Paramaters.Refresh
cmd.Paramaters(1).Value = me.FieldContainingBarCode

cmd.Execute

set cmd = Nothing

I think this will work too

Dim cn as NEW ADODB.Connection

Set cn = CurrentProject.Connection

cn.Execute "EXEC NameOfSP '" & me.FieldContainingBarCode & "'"

set cn = Nothing

can you use the answer here?

its easier to help with a bit of feedback

status it-manden?

Sorry
Det virker takker

Great

it-manden.dk can you close the question if your happy with the answer? Thanks.

tak

selv tak