Pop up prompt to enter data

[Sturmtruppe]

I've got a yes/no field called 'SchoolPickup' whereby the user enters 'yes' or 'no' depending on whether a customer has decided to pick their items up from school or not.

The problem is, I would rather a pop up prompt asking yes or no was displayed once id entered the name of the school in the 'SchoolName' field. However, im not even sure if this is possible?

 

[missinglinq]

A couple of way to do this. One would be with a Messagebox. Not 100% sure of exactly what you want here but this should get you started.

Private Sub SchoolName_AfterUpdate()
If Nz(Me.SchoolName, "") <> "" Then
 
 If MsgBox("Would you like to pickup from the school?", vbYesNo) = vbYes Then
  Me.SchoolPickup = "Yes"
 Else
  Me.SchoolPickup = "No"
 End If
  
End If
End Sub

Linq ;0)>

 

[Sturmtruppe]

Great, thanks thats exactly what I needed.

A prompt will help my users remember to note this on their fax orders.