Click on datasheet cell copies value from another column to perform query

[JayS.]

Hello friends!



I have a database and have hit a wall with an action that I need to perform.

Essentially, when a records cell is clicked in datasheet view I need it to copy a value from another column in that record and store it for use in a query to return the appropriate items in another table.

I think I can get all I need for the query, I'm just struggling with how to copy data from a record (in another column then the one clicked. I'm thinking it's an "on-click" event? The clicked cell is listed as a hyperlink to give it the appearance of a "clickable" item.

In the example below, I want to click on the "Show List" link and copy the UserID value in the same line for use in a query to return only the items that pertain to that UserID.



I appreciate your time.

Jay

[JayS.]

Well, I figured it out and now feel silly. All I needed to do was create a string and reference the UserID field to load the value into the string.

Dim myUserID as string
myUserID = Me.UserID.Value

All good now!