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

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top