By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,996 Members | 1,179 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,996 IT Pros & Developers. It's quick & easy.

updating bound & unbound controls on a form?

P: n/a
MLH
I have a form, bound to a query. Its RecordSource property
is a query named frmEnterLienAmounts. The form has a few
bound controls and some unbound controls. The unbound
controls are calculated fields whose DefaultValue property
is set to something like

DLookUp("[TowFee]","tblVehicleJobs","[VehicleJobID]=Forms!frmEnterLienAmounts!VehicleJobID")

The form (frmEnterLienAmounts) has, as one of its bound
fields [VehicleJobID]. As I scroll through the records, one-
by-one, I am surprised to see that the unbound controls
are NOT updating. I even put Me.Recalc in the OnCurrent
form property. That doesn't help, the values in the unbound
controls stay the same while flipping from record-to-record
on the form. They stay equal to the amounts calculated for
the very first record in the record source query dynaset. I need
for them to change when flipping through the records. How?
Nov 13 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
MLH
Oops, sorry. The query name is
qry262CorrespRecsW0matching262SpecificRecs. The
form name is frmEnterLienAmounts.

xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx xxxxx
I have a form, bound to a query. Its RecordSource property
is a query named frmEnterLienAmounts. The form has a few
bound controls and some unbound controls. The unbound
controls are calculated fields whose DefaultValue property
is set to something like

DLookUp("[TowFee]","tblVehicleJobs","[VehicleJobID]=Forms!frmEnterLienAmounts!VehicleJobID")

The form (frmEnterLienAmounts) has, as one of its bound
fields [VehicleJobID]. As I scroll through the records, one-
by-one, I am surprised to see that the unbound controls
are NOT updating. I even put Me.Recalc in the OnCurrent
form property. That doesn't help, the values in the unbound
controls stay the same while flipping from record-to-record
on the form. They stay equal to the amounts calculated for
the very first record in the record source query dynaset. I need
for them to change when flipping through the records. How?


Nov 13 '05 #2

P: n/a
MLH wrote:
Oops, sorry. The query name is
qry262CorrespRecsW0matching262SpecificRecs. The
form name is frmEnterLienAmounts.

xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx xxxxx

I have a form, bound to a query. Its RecordSource property
is a query named frmEnterLienAmounts. The form has a few
bound controls and some unbound controls. The unbound
controls are calculated fields whose DefaultValue property
is set to something like

DLookUp("[TowFee]","tblVehicleJobs","[VehicleJobID]=Forms!frmEnterLienAmounts!VehicleJobID")

The form (frmEnterLienAmounts) has, as one of its bound
fields [VehicleJobID]. As I scroll through the records, one-
by-one, I am surprised to see that the unbound controls
are NOT updating. I even put Me.Recalc in the OnCurrent
form property. That doesn't help, the values in the unbound
controls stay the same while flipping from record-to-record
on the form. They stay equal to the amounts calculated for
the very first record in the record source query dynaset. I need
for them to change when flipping through the records. How?


In the OnCurrent event, if the fields aren't updating, you can enter
Me.CalcFieldName.Requery

Is there any difference if you enter
=DLookUp("[TowFee]","tblVehicleJobs","[VehicleJobID]=" & ME.VehicleJobID)
in the controlsource instead of Form!... method?
Nov 13 '05 #3

P: n/a
Maybe

DLookUp("[TowFee]","tblVehicleJobs","[VehicleJobID] _
= " & Forms!frmEnterLienAmounts!VehicleJobID)

"MLH" <CR**@NorthState.net> wrote in message
news:sp********************************@4ax.com...
I have a form, bound to a query. Its RecordSource property
is a query named frmEnterLienAmounts. The form has a few
bound controls and some unbound controls. The unbound
controls are calculated fields whose DefaultValue property
is set to something like

DLookUp("[TowFee]","tblVehicleJobs","[VehicleJobID]=Forms!frmEnterLienAmounts!VehicleJobID")

The form (frmEnterLienAmounts) has, as one of its bound
fields [VehicleJobID]. As I scroll through the records, one-
by-one, I am surprised to see that the unbound controls
are NOT updating. I even put Me.Recalc in the OnCurrent
form property. That doesn't help, the values in the unbound
controls stay the same while flipping from record-to-record
on the form. They stay equal to the amounts calculated for
the very first record in the record source query dynaset. I need
for them to change when flipping through the records. How?

Nov 13 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.