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? 3 4980
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?
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?
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? This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Farshid Lashkari |
last post by:
Hi,
I have an object and I want to check if it is a bound or unbound method,
or neither. I tried using the types module, but it seems as though
types.UnboundMethodType and types.MethodType are...
|
by: google |
last post by:
I'm developing an application for use within my company in Access 2003.
I'm new to '03, the application I did for my former employer was in
'97. The two applications have similar functionality...
|
by: planetthoughtful |
last post by:
Hi All,
I have a mainform with a subform in which I show some task summary
data.
On the mainform I have a number of unbound controls that reflect values
relevant to each task in the subform....
|
by: SBC News Groups |
last post by:
Using VBA how do I assign columns from a table to controls on an unbound
form?
Mike
|
by: ccsnavy |
last post by:
For some reason referencing an unbound control on an active form from a query has ceased to work correctly. While other previously existing references to unbound controls in the same form seem to...
|
by: ARC |
last post by:
I've noticed that if you use code for the before update command for unbound
controls, it doesn't really work.
I tried the following:
Me!ExportedYN.undo
Cancel = True
DoCmd.CancelEvent
Exit...
|
by: NaftoliGug |
last post by:
Is there a way to have unbound, uncalculated controls (or a calculated control that is based on a function) that retains a different value for each record?
|
by: hbaf208 |
last post by:
I have a combobox on a subform that is based on an SQL that uses a listbox on the unbound parent form as the criteria. When the form is first loaded, it works perfectly, limiting the dropdowns to...
|
by: Mike Hall |
last post by:
MS Access 2007. When doing a simple record select and copy on a continous form, all the unbound controls in the form header get copied as well. Evidence of this is seen if you paste into Excel.
...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
| |