That's the error I am receiving when I am trying to click a button, on a bound form to a table, that executes this code:
Expand|Select|Wrap|Line Numbers
- Private Sub HomeBtn_Click()
- Call ElectionAwardUpdate
- DoCmd.Close acForm, Me.Name
- DoCmd.OpenForm "Home"
- End Sub
Expand|Select|Wrap|Line Numbers
- Public Sub ElectionAwardUpdate()
- 'update non-identifying foreign key to reflect new elections
- DoCmd.SetWarnings False
- DoCmd.OpenQuery "UpdateAwardPriElectionQry"
- DoCmd.OpenQuery "UpdateAwardSecElectionQry"
- DoCmd.SetWarnings True
- End Sub
Any ideas? Thank you.