Auto Populate Fields in a Form

[Jamie Dickerson]

Ok this will be a doozy. Right now I have a form where work done in the
plant can be entered (Production Form). At this moment all quotas must be
manually entered into the form (fine for me as I have most memorized). What
I would like to do is have the quota field automatically populate based on
the item# and machine type (there are 9).

I know to get started I will have to create tables for each type of machine
that lists the item#'s and the standard. Then I am pretty sure I have to
build some kind of code telling access where to grab the information based on
the entry in the machine field of the form.

Am I on the right track? If so could someone give me an example or starting
point for the code?

 

[Jamie Dickerson]

Jim,

I used your code but I recieve a type mismatch. All fields are numeric
except the Item# it is a combo of text and digits. The only other thing that
my be causing the error is in the combo box for machine. I have two columns,
one numeric ID the other the machine name. I have made the first column
invisibile as most data entry personnel will not know the machine ID only the
name of the machine. Your help is appreciated.