Auto fill field in a table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I thought I had this one figured out, but I need this to work on my table if
at all possible. How can I fill a field in a table based on another field in
that same table? Two of my fields in my table are Program and Company. When
Program is filled I need Company to fill automatically. They are related. I
know I can do this on a form, but I really need it to work on my table. Any
help is appriciated.
 
There are no Triggers in Access MDBs so it can't be done without a form. To
be fair, you shouldn't ever be working directly in tables for data entry
anyway. If you need the convenience of the datasheet, run a form in
datasheet view.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access Downloads
http://www.datastrat.com
http://www.mvps.org/access
 
In that case can you help me with some code on my form? I have a field named
Program(ComboBox) and another named Company(TextBox). I can get it to
display the company when the program is selected by changing the control
source to =Program.Column(1), but this is no good because I need the company
to be recorded in my table and this doesn't do that. I thought that

[Company] = [Program Type].Column(1)

in after update would work but it doesnt. It is telling me that the macro
doesn't exist. What am I doing wrong? Any ideas?
 
Back
Top