473,837 Members | 1,518 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Bound table updates in one field but not another. A97

MLH
I have a form used as a subform on frmCreateInvoic e.
It is displayed in datasheet view in the subform control.

It displays a few text fields, a boolean field (shown as a
checkbox control) and a numeric field. The subform is
fed by a query. When I open the main form, I often click
the checkbox control in the records listed in the subform
control, changing them from False to True. And in the
numeric field, I may change the displayed values. The
source query is comprised of several tables. Only one
table's values are affected by my actions. Both fields
that I modify are in the same table (TempTable) and that
table is the only one in the src query whose values are
changed by user intereaction on the form.

Interestingly enough, here's what I've discovered: The
underlying TempTable value is IMMEDIATELY affected
when I click a checkbox control, changing it from True
to False or vice versa. The same is NOT true, however,
If I type a new value into the number field and press ENTER.
Of course, if I move off the record both field changes are
saved to the underlying table TempTable, as would be
expected.

Why is it that clicking the checkbox associated with the
boolean table field results in instantaneous value change
at the table level?
May 1 '07 #1
1 1751
Is the check box the last one that has a Tab Stop in the Tab Order of the
subform?

If not, post the query statement.

There is a weird problem associated with default values in the *other*
tables. If any of the field in tables other than the one you intend to write
to (TempTable) have a Default Value set, and if this problem occurs at the
new record, it may be related to that bug.

The issue could also be caused by other events in the form (code/macros), or
by other calculated controls that update and trigger the write, if those
controls were in some way dependent on the check box.

It might be interesting to verify the timing of the write through the form
by adding a Debug.Print statement to the BeforeUpdate event of the *form*,
e.g.:
Private Sub Form_BeforeUpat e(Cancel As Integer)
Debug.Print "Record " & Me.ID & " written at " & Now()
End Sub

Then watch the Immediate Window (Ctrl+G) for when the write occurs.

HTH.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"MLH" <CR**@NorthStat e.netwrote in message
news:jd******** *************** *********@4ax.c om...
>I have a form used as a subform on frmCreateInvoic e.
It is displayed in datasheet view in the subform control.

It displays a few text fields, a boolean field (shown as a
checkbox control) and a numeric field. The subform is
fed by a query. When I open the main form, I often click
the checkbox control in the records listed in the subform
control, changing them from False to True. And in the
numeric field, I may change the displayed values. The
source query is comprised of several tables. Only one
table's values are affected by my actions. Both fields
that I modify are in the same table (TempTable) and that
table is the only one in the src query whose values are
changed by user intereaction on the form.

Interestingly enough, here's what I've discovered: The
underlying TempTable value is IMMEDIATELY affected
when I click a checkbox control, changing it from True
to False or vice versa. The same is NOT true, however,
If I type a new value into the number field and press ENTER.
Of course, if I move off the record both field changes are
saved to the underlying table TempTable, as would be
expected.

Why is it that clicking the checkbox associated with the
boolean table field results in instantaneous value change
at the table level?
May 1 '07 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

5
14551
by: John Sheppard | last post by:
Hi there Does anyone know how to fill a bound textbox automaticlly. In an unbound textbox I would put in the control source =Sum(price, tax) (or some such function) and access updates it automaticlly. Is there a way to do the same thing on a bound textbox so that it is automaticly updated?
1
2283
by: L Mehl | last post by:
On my cmdSaveRecord, I check a couple of fields to confirm that an entry has been made before allowing the Save. I decided to - not put validation rules in table structure, and - validate on Save to avoid annoying the user if a field was left empty before clicking cmdSaveRecord For each field validated in this way, I was getting an error something like
2
2302
by: Megan | last post by:
Hi everybody- I have 2 tables, Hearings and Rulings. Both have primary keys called, CaseID, that are autonumbers. I don't want both tables to have the same autonumber. For example, if Hearings has 55, then I want Rulings to have a number greater than 55. Two or more Hearings may be entered before a Ruling is entered. For example, Hearings with CaseIDs= 55, 56, and 57 may be entered before a Ruling or vice versa. There is no definite...
19
4119
by: James Fortune | last post by:
I have a lot of respect for David Fenton and Allen Browne, but I don't understand why people who know how to write code to completely replace a front end do not write something that will automate the code that implements managing unbound controls on forms given the superior performance of unbound controls in a client/server environment. I can easily understand a newbie using bound controls or someone with a tight deadline. I guess I need...
14
10151
by: Abhi | last post by:
FYI: This message is for the benefit of MS Access Community. I found that this prblem has been encounterd by many but there is hardly any place where a complete solution is posted. So I thought I should give back to the community by posting our findings. Thanks you all for all your help till now by posting problems and their solutions. ~Abhijit
4
2972
by: vulcaned | last post by:
Hi All, Hopefully I explain this well........ In Access97 I have a form which has a tab control on it, each tab has a sub-form which is bound to its appropriate table(I'll call them 'Detail' tables). I have a 'Header' table and fields from it are displayed on the form above the tab control. Header table name is tblClientInfo Detail tables are tblPolicyInfo, tblBeneInfo, tblRiderInfo
7
2841
by: vsiat | last post by:
I am trying to create a treeview out of a database table with the typical structure ID, NAME, PARENTID, TYPE, EXTRA_INFO, where is linked to the . What I want to achieve is create a tree made of custom, extended nodes, which include all the extra information contained in the table and not just typical TreeNode objects. To do that, I first created a structure with all the extra
4
4623
by: jon f kaminsky | last post by:
Hi- I've seen this problem discussed a jillion times but I cannot seem to implement any advice that makes it work. I am porting a large project from VB6 to .NET. The issue is using the combo box bound to a table as a lookup, drawing values from another table to populate the available selections. This all worked fine in VB6. I have distilled the problem down to a simple form drawing data from the Northwind database for a representative...
2
2156
by: cjard | last post by:
Suppose: A TextBox is bound to a BindingSource, which is bound to a DataTable A BindingNavigator is used to alter the current row being looked at by the BindingSource (i.e. Nav's NEXT button is pressed. BS.Position changes from 2 to 3, Textbox was showing APPLE, now shows ORANGE) Does the textbox receive any notification that this occurred? If so, what?
0
9837
marktang
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, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
9682
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 effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
10563
jinu1996
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 tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
0
9392
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
7804
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
6998
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
5668
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
1
4474
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
3
3123
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.