i have form utilizes query recordsource update table in end. query , table identical. right now, have few columns hidden in query don't show on data sheet in split form view when records being updated. however, because these fields hidden, new record can't updated enough information values table because values hidden columns aren't set.
is there way set default value every new record created hidden columns? example want column named "location" pull default value new record created not shown on form. have created temporary variable default value new record. tried setting tables default value temporary variable doesn't work.
you should use beforeupdate_event of form. way before new record committed table , error message pops can assign values hidden columns.
dim mtempvariable string '* set value temporary variable. '* make sure set. form_load event place. private sub form_beforeupdate(cancel integer) me.txtlocation = mtempvariable end sub 