468,769 Members | 2,293 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,769 developers. It's quick & easy.

updating bound & unbound controls on a form?

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
3 4628
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
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
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.

Similar topics

2 posts views Thread by Farshid Lashkari | last post: by
5 posts views Thread by SBC News Groups | last post: by
1 post views Thread by CARIGAR | last post: by
1 post views Thread by Marin | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.