Auto fill based off combo box

[17PSI]

I have a Client form and table with name, address, etc. as well as the services that they are using. I would like to be able to look up a service from the service table and fill in the related fields. I tried the wizard, but it only allows you to store 1 value in the db. Also find a record based on my selction will not work because the services table is used only as a lookup table, but it contains four fields that I would like to store in the Client table. Also I do not want to make a relationship between the tables because some of the data may need to be edited.

Thanks in advance for the help!

 

[Adrianna]

If you're using a combo box in the form to auto fill based on your services selection, then you should select the third option in the Combo Wizard that asks if you would like to provide other data based on your selection. This will allow you to have the user select a service and then the records related to that service will become available.

If you are unclear on the used of Combo Boxes, or how to utilize the auto fill functionality.....use this Forums search function. There are plenty of very useful postings that already exist regarding autofill using combo boxes!