Access 2003-you must save the current field before you run the requery action

B

bjgoen

Joined
Feb 24, 2011
Messages
2
Reaction score
0
I had the following code in 2000. Recently updated to 2003. Now when you enter information you get "you must save the current field before you run the requery action"

If IsLoaded("frmProperties") Then
Forms![frmProperties]![frmPropertiesTitleCompanies].Form![txtTitleCompany].Requery
DoCmd.Close
Forms![frmProperties]![frmPropertiesTitleCompanies].Form![txtTitleCompany].Requery
Else
DoCmd.Close
End If

Attemped to do this (have this code on 2 different sub forms - one for Title Companies, one for Mortgage companies)

Set ctlCombo = Forms![frmProperties]![frmPropertiesMortgageCompanies].Form![txtMortgageCompany]

DoCmd.Save
If IsLoaded("frmProperties") Then
If Me.Dirty = True Then Me.Dirty = False
ctlCombo.Requery
DoCmd.Close
ctlCombo.Requery
Else
DoCmd.Close
End If

I don't know what I am doing wrong as this has never been an issue in the past.

Thanking you in advance for any help
 
Back
Top