conditional default value in a table / form

[treborstetsam]

amongst the columns in my table are 2 - "Purchased" and "Unprompted", what I would like to do is:

If Purchased = Yes then Unprompted = Yes
If Purchased = No then Unprompted could be Yes or No, which can then be set by the user.

My thinking was I could set the default value of Unprompted to be =IIF([Purchased]=Yes,Yes, No). I would then be able to override it for any Purchased=No, Unprompted = Yes results.

If I can't achieve this directly within the table design do you know of any other means, possibly through a form control?

[MMcCarthy]

amongst the columns in my table are 2 - "Purchased" and "Unprompted", what I would like to do is:

If Purchased = Yes then Unprompted = Yes
If Purchased = No then Unprompted could be Yes or No, which can then be set by the user.

My thinking was I could set the default value of Unprompted to be =IIF([Purchased]=Yes,Yes, No). I would then be able to override it for any Purchased=No, Unprompted = Yes results.

If I can't achieve this directly within the table design do you know of any other means, possibly through a form control?

You cannot do it in table design.

However if you have a form based on the table then in the after update event of the [Purchased] control you could put the following code.

Private Sub Purchased_AfterUpdate()
 
   If Me.Purchased = -1 Then ' this assumes that Purchased is a checkbox
      Me.Unprompted = -1
   Else
      Me.Unprompted = 0
   End If
 
End Sub
 

[treborstetsam]

Thanks - that worked fine on the form, will keep this one safe - can see further uses for it..

[NeoPa]

That would set a good 'running' default for [Unprompted].
If you want to leave its pre-existing value when [Purchased] is set to No but set it to Yes when [Purchased] is set to Yes then :

Private Sub Purchased_AfterUpdate()
    If Me.Purchased Then Me.Unprompted = True
End Sub

Robert Masters I presume?