MS Access returning a value from a stored procedure

[madmax262]

I have created this VB script which triggers a stored procedure and enters a sales transaction into a table. All works well but I am struggling with is getting the Tran_No back from the table once the record has been entered?


See attached for more.

Can anyone urgently assist me with this one?

[Oralloy]

madmax262,

Show us how you're entering records, so that we can help you modify your work...

Cheers!
Oralloy

[madmax262]

Hi, thanks for coming back to me on this one. I managed to solve it myself.

I wouldn't mind some help in solving this one though: -

https://bytes.com/topic/access/answers/967351-running-stored-procedure-access-populate-local-table