Updating tables

  • Thread starter Thread starter Greg
  • Start date Start date
G

Greg

I have an unbound combo box with drop down list that can
identify a record from a table. My primary key of my
table appears in my drop down list of the combo box. When
my form is filled with the required info, I want to take
these values (from the controls) and manually update the
fields of my table. Would coding be the best route and if
so how do I reference the primary key to update its
fields in the table?. A little detail will be appreciated.
Thanks for the help
Greg
 
Why do you want to do this manually?
If you'll bind the form to the underlying table, and build your combobox
using the third option in the wizard (something like "go to a record based
on the value in the combobox"), this will all be taken care of for you.
It's what Access does best!

HTH
- Turtle
 
The reason is that
1) I need to know how to manipulate access, talk
directly to objects if the wizard is not used. In this
way I learn more about what access is all about.
2) There are other calculated values that do not
appear on the form but needs to be stored in the table.
Therefore a manual method would be preferred in this
instance
Thanks
 
IMHO "what Access is all about" is bound forms.
This is not a wizard - this is very basic Access functionality.

One thing Access does not require is storing the results of calculations
which can be performed on an as-needed basis.

I suggest you find an elementary text on Access and begin to learn the
concepts between this very powerful relational database program.

HTH
- Turtle
 
Storing calculated values is rather like rigging the
refrigerator light to stay on when the door is closed.
When you open the door, the light is on. Whether it was
on before you opened the door is irrelevant.
I learned Access in part by using wizards and then looking
at the code they produced. Wizards can be a helpful
learning tool. If you don't want to use wizards, you will
need to learn VBA coding (which you will need to know to
at least some extent anyhow). Manually updating tables
solves nothing, and is quite contrary to "what Access is
all about".
 
Back
Top