Combo Box Auto Populating Fun!!!

[Beckwa]

Hello!! Could any one please tell me how you can auto populate a text field from a selection in a combo box. Making a animal hospital appointment system. Doing the input form and when the treatment ID is selected from the drop down combo box, I want the treatment name and treatment price to appear automatically on the form.

Any help would be gratefully received!!!!

bex

 

[Norie]

Create a form based on the appropriate table e.g Tretaments

Add the Combo Box using the wizard, select third option at first step then the treatrment ID and then the other required fields.

Then add the other fields to the form.

You might want to set a default for the Combo Box.

 

[Beckwa]

Thanks for the help, but couldn't get it to work. It doesn't seem to add the Treatment Type and Treatment Cost from the separate Treatment table I have created, to the Input form!!!

 

[MustBNuts]

Okay, I just tested this and it worked:

Go to the design view of the query your form is based on. Add the Treatment table to the query, then add TreatmentName and TreatmentPrice from the Treatment table to the query. The TreatmentID should be a set up in the Appointment table as a lookup field and should be in the current query (in other words, make sure TreatmentID is coming from and being stored to Appointment table, NOT the Treatment table).

Once the two new fields are in your query, go into your form, delete the existing TreatmentName and TreatmentPrice fields and, using your field list, drop the two new fields in.

This should work fine.

Hope this helps,

MBN