Access Data Macro - Looking up a record using a value in a variable
Posted on 2016-07-18
I have a named data macro (in Access 2013), which when called, I want it to find a specific record (within the table for which it is attached to) based upon a record key, which is saved in a tempvar. The tempvar is set in the macro which calls the data macro. However, I cannot seem to figure out how to get it to use the tempvar in the where condition.
Here is a better picture:
TVarSWSerKey = 71 (this tempvar is set in the calling macro, before the datamacro is called)
[sw_serials].[ser_key] = (this is a numerical field in the sw_serials table, and is the primary key)
Datamacro: sw_serials.uninstall (datamacro "uninstall", on the "sw_serials" table)
Look Up A Record In sw_serials
Where Condition = [sw_serials].[ser_key] = FormatNumber([TempVars]![TVarSWSerKey])
The above where condition, does not seem to grab any record. If I replace "FormatNumber......" with the number 71, then the where condition successfully grabs the record with ser_key of 71. I've without the FormatNumber function, and with various different quotation formats, but can't seem to get it to work.