Is there any way to set a new default value for records in a given field via VBA?

Thanks in advance

in the form load event use:

me.fieldname.value=24

or

me.fieldname.value = date for today's date

me.fieldname.value="zyx" for a string etc

hmmm... i think i should rephrase that. is there a way to programmatically change the default value defined for a field within a given table? meaning... when new records are entered into the table, they will automatically default to the newly created default value for the field in question.

Thanks

basically the same thing

me.fieldname.defaultvalue="xyz"

cool. thanks, i'll try that out.

I must be doing something wrong. I tried setting the 'Default Value' property for the field in question to:

Forms![frmUpdRate]![txtRate]

and tried saving the table. I got an error message:

"Could not find field 'Forms]![frmUpdRate]![txtRate'."

I also tried querying another table for the value using the following SQL:

select intrate from rate where entry = 1

I got an error message saying:

"The syntax of the subquery in this expression is incorrect.

Check the subquery's syntax and enclose the subquery in parentheses."

As you can see, there is no subquery to enclose in parentheses.

Any ideas? Thanks!

Ok

Using your information of fields the code should be

Private Sub Form_Load()

  me.txtRate.DefaultValue=1
  'any other code you need to enter

end sub