Automatically populate fields

  • Thread starter Thread starter REMMY06
  • Start date Start date
R

REMMY06

I know this is simple but can't seem to find the right thread. I have a
table with 4 fields; AutoID, Code, Service & Rate. They are already
prepopulated with information. I have made a form and created the combox for
the "service" field and would like to have the "Code" and "rate" information
automatically populate when the service is selected.

Thanks for any help.
 
Join your table in the query for the form.
I know this is simple but can't seem to find the right thread. I have a
table with 4 fields; AutoID, Code, Service & Rate. They are already
prepopulated with information. I have made a form and created the combox for
the "service" field and would like to have the "Code" and "rate" information
automatically populate when the service is selected.

Thanks for any help.
Click to expand...
 
make your combo a multi column combo and include each field you want to use
to populate controls on the form. Then, in the After Update event of the
combo, populate the controls using the combo's Column property.
 
Thanks
I think I am half way there but everytime I try to populate it shows #Name
error. Can you show me an example of the code to populate the other fields?
make your combo a multi column combo and include each field you want to use
to populate controls on the form. Then, in the After Update event of the
combo, populate the controls using the combo's Column property.
I know this is simple but can't seem to find the right thread. I have a
table with 4 fields; AutoID, Code, Service & Rate. They are already
Click to expand...
[quoted text clipped - 3 lines]
Thanks for any help.
Click to expand...
Click to expand...
 
Back
Top