Default value in field based on value in other field

[smith.jr]

I have a table with field_1 and field_2. If "NO" is entered in field_1, I would like the default value in field_2 to be "N/A". If field_1 is something other than NO, the default value in field_2 should be null. Both fields are required. Any suggestions?

Thanks in advance for your help.

[ItsMe]

In situations like this I manage it at the form level using the after update event.

if me.field1 = "No" then
me.field2 = "N/A"
end if

Newer versions of Access probably have a way to manage this at the table level. If you are planning to use your app as a web app then you might consider trying to get it done at he table level.

[orange]

Tell us more about your table in plain English. Seems there may be a design issue with your fields (to me anyway).