Should be a very easy question

[chris9]

I want my form to look up a columns value and if the column is empty insert a character(example: "n&quot. I've tried to alter the table with a sql statement but that doesn't seem to be working. I know this should be fairly simple but I'm not having any luck.

Thanks so much

 

[jrbarnett]

Use this as the basis for your AfterUpdate control. You will need to change the table name and field name and key column, but the structure is there:

If IsNull (Dlookup ("Value", "Field", "Key='value'")) Then
  DoCmd.RunSQL "Update table set key='n' where key='value'"
end if

John