Passing a Field Value to VBA Procedure

[tonygg]

Sorry to be asking a very dumb question but ...

I have a form displaying the contents of a table in a datasheet view. I want to click on a row and open up a new form that will use a field in the selected row as a parameter.

I know how to call the VBA procedure by setting the double click on field (Cant do it for click on any fields in the row?) and in the VBA was using:

strText = Me.[Product Reference].Value



to get the required value. However this only seems to work in single form view. If it is in datasheet view it gives an error and will not let you save the form.

I am guessing I am missing the row identifier in my VBA code. I have tried to search on the forums but I am obviously not using the right VBA speak as I cant find an example.

Please could someone help me out?

Many thanks Tony

[pbaldy]

That should work. What is the error? Is this what you're trying to do?

http://www.baldyweb.com/wherecondition.htm

[tonygg]

Thank you. That helps. I got the syntax wrong. It works now.

[pbaldy]

Happy to help.