Which field isn't updating, and what kind of control is it? I don't
understand why you're trying to duplicate the information on the form,
because you're pulling the values from your dropdown.
I notice you're also using dots and bangs interchangeably . You may
want to browse through this as it may also be part of your problem:
Addressing Objects and Collections
Access provides a method that lets you address anything within your
database. Since objects and collections form a hierarchical system, it
may be helpful to compare the Access address system to a similar system
you should already be familiar with--the directory structure on your
disk drive.
As you move through different levels in a directory structure, you
indicate a change in level using a backslash. For example, consider the
following pathname:
C:\WINDOWS\SYST EM\SYSEDIT.EXE
As you read the pathname from right to left, you learn that the
SYSEDIT.EXE file is in the SYSTEM directory, which is within the
WINDOWS directory, which is on the C: drive. Each backslash indicates
you are moving down a level in the directory structure, when reading
from left to right. In Access, you use exclamation points (!) and
periods (.) to denote changes in the level. The exclamation points are
called bangs, and the periods are called dots. The general rules which
govern the use of bangs and dots are as follows:
You use a bang before objects you have named.
If a name contains spaces, you surround it with brackets, as in [Zip
Code].
You use a dot before objects, properties, or methods named by Access.
How do you apply these rules? Simple. Suppose you want to refer to the
Business Customers table you created earlier in this book. This table
is part of the Customer database, so you can address it as follows:
Customer![Business Customers]
Notice the brackets around the table name and the bang between levels
of the hierarchy. If you want to refer to a property within the table,
you can use a dot and the property name, as in the following:
Customer![Business Customers].RecordCount
Michael Bialowas wrote:
Hello all, I have been searching the net endlessly and found this ng, so I
thought I would give a try. Anyways, I have a few problems I am trying to
implement a combo box which presently contains the following: Description,
Price, and Treatment code. I wish to do the following: when the description
field(combo box) is clicked I want the price, treatment code, insured field
to become automated(updat e the corresponding data automatically). At the
present time 3 out the for 4 fields are updating fine. Basically the
description field contains the products and services offered. I used a check
box(boolean value) to be able to tell the difference as to what insurance %
should be applied,however , it is not working. Furthermore, the field used
for the insured % is used further for more calculations. Is there not a way
I can just set the field to read to the correct value in visual basic. I get
the following error at the present time.
Run-time error ' 2147352567(8002 0009)'
You can't assign a value to this object.
Private Sub ProductID_After Update()
Me![UnitPrice] = Me![ProductID].Column(2)
Me![ProductCode] = Me![ProductID].Column(3)
Me.Foot = Me![ProductID].Column(4)
Me.Pod = Me![ProductID].Column(5)
End Sub
any feed back greatly appreciated.
Thanks in advance