title: Field default value from query in MS Access
body: <p>I have a field on a table in MS Access, tblMyTable.SomeID, and I want to set the default value as a user preference in tblUserPref.DefaultSomeID.  It doesn't appear that I can set the default value to use a query in the table definition of tblMyTable.  I have a form where records are entered into tblMyTable.  I've tried to set the default value of the field on the form, but doesn't seem to accept a query either.  So, as a last resort, I'm trying to do it with VBA.  I can query the value that I want in VBA, but I can't figure out which event to attach the code to.</p>
  
  <p>I want to run the code whenever a new blank record is opened in the form, before the user starts to type into it.  I do not want to run the code when an existing record is opened or edited.  However, if the code runs for both new blank records and for existing records, I can probably code around that.  So far, all of the events I have tried on the field and on the form itself have not run when I wanted them to.  Can anyone suggest which event I should use, and on which object?</p>