Losing data in one field when backtracking thru records.

[FrankMars]

I enter a form and go to a new record. In one of the 20 fields on the form I have a pop-up calculator which fills out a
field. I finish the record and go to the next new record. If I happen to use the previous button and go back thru the records, the field with the pop-up calculator blanks out. The further I go back the more info I lose in that particular field. I'm a beginner, any ideas?

 

[dhookom]

Is the control bound?
Is there any code or macro in the form?

Duane
Hook'D on Access
MS Access MVP

 

[FrankMars]

Hi Duane- Yes, the control is bound. I want the data to show in my main table. Yes, there is code in the form e.g. the pop-up calculator feeding the problem field.

 

[dhookom]

When I asked if there was code, I was expecting you to share it with us.

Duane
Hook'D on Access
MS Access MVP

 

[FrankMars]

Sorry!

Private Sub btnEnter_Click()

Forms!faEnterHouse!tbxLandSF = Me.tbxLandSF

Forms!faEnterHouse!tbxLandOrigPricePerSF = Forms!faEnterHouse!tbxLandOrigListPrice / Forms!faEnterHouse!tbxLandSF

DoCmd.Close acForm, "fnCalculatorLandEntryLandSF"
DoCmd.OpenForm "fnChooserLandTarget"

End Sub

 

[dhookom]

You need to explain what form the code is running in and what the other forms do.

What happens if you comment out the code?

Have you set a breakpoint in your code to see what is happening?

Duane
Hook'D on Access
MS Access MVP