Table Default Field Value set to Public Variable

[Binnit]

I would like to set field default value to that of a Public Variable.

I have a Public variable called DefaultAgency

I would like to set a table field default value to the current value of the variable.

Is this possible?

If IT ain’t working Binnit and Reboot

 

[jebry]

Hi!

I don't think you can. But, if the data will be entered using a form, then you can use the Current event to put the value of the global variable into the field whenver the user goes to a new record.

hth


Jeff Bridgham
Purdue University
Graduate School
Data Analyst

 

[Golom]

You can set the default value for a field with

Dim cat As ADODB.Catalog
Set cat = New ADODB.Catalog
Set cat.ActiveConnection = <Some Connection Object>

cat.Tables("myTable").Fields("myField").Properties("Default") = Var

However that sets the field default to the current value of "Var". It would need to be executed again whenever the value of "Var" changes.