Is there a way for a macro to check if the current record is blank/new?

[agerber85]

I need my macro (more specifically, my if statement) to check whether the active record in a specific subform is blank or a new record.
My macro currently sets the value of a field to the current DB user’s ID (looked up through a SQL query), but I need to prevent overwriting existing records.

[Ratslinger]

Hello,

Please see my answer in this post → base auto populate new record

[agerber85]

Thanks! I like your solution better than mine.

[agerber85]

Got it!

I simply enclosed the commands that set (and committed) the value of the field in an if statement that checked if isempty(oController.SelectedValue), where oController is the controller object for the field that I’m having the macro auto-fill.