Populate field based on values in another field
Posted on 2014-12-10
On a form I have a field that may read, "Baseball, Football, Basketball".
If in that string of characters there is "Football", I want a second field to populate with "30". Otherwise "90"
Here is my oncurrent event code that is not working:
If InStr(txtGames, "Football") Then
Me.txtNumber = 30
Me.txtNumber = 90