You can create a query that include all the fields from
the table + another field that based on a function that
return tha value of the variable.
"Select *.MyTable, GetVar() as MyVar from MyTable"
function GetVar()
GetVar=MyPubVar
end function
>-----Original Message-----
>Can i set a table field to gets its value from a public module variable in
>access?
>.