Automatically populate fields

[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.

 

[ruralguy via AccessMonster.com]

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.

 

[Guest]

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.

 

[ehyett]

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

[quoted text clipped - 3 lines]

Thanks for any help.