assigning recorrdset value to a textbox

G

Guest

Hi,
I have a stored procedure which returns a single value, assigned toa
recordset variable, rst. I want to put this value into a textbox on an Access
Project form. However, txtbx.value = rst doesn't work.

Am I right in thinking that I have to convert the rst value into a string
(or other compatible form for the text box value), and if so, how do I do
this?

many thanks,

Pete
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Assign the records shown in a subform to a recordset 2
Assigning a value to an unbound textbox 4
Microsoft VBA and Printing to templates using code 1
Append loop working but causing duplicates - I'm lost 3
Runtime error #2448 Cannot assign value to this control 2
Using Variables in a WHERE clause 2
Currenct issue with a text box 1
Avoid duplicate entries 1

Top