assign variable with double click

[tlove161]

How can I assign a variable to the active record in a table with the double click event of a command button? I am somewhat knowledgeable of vba. I did a search but found nothing. Thanks.

 

[lupins46]

I'm not really sure what you mean by:'assign a variable to the active record '.

DO you mean that you want to put a value into textbox on the form?

If so the code you would use would be like:

me.textboxname = value

I would be quite careful about using the double-click event AND the click event for the same control, if that's what you had planned.

 

[randy700]

Something like...

Dim db as DAO.Database
Dim strSQL As String
Set db = CurrentDb
strSQL = "UPDATE YourTable SET FieldName = YourVariable WHERE you need to identify the record here
db.Execute strSQL





Randy