Auto populate

[Guest]

I've tried to understand how to do this via the other posts but I need to use
my own data to understand.
I would like fields in a form to automatically populate when choosing from a
drop down menu.
So if x then several values will populate several fields. Ex: if flower
then rose, daisy, petunia OR if plant then rose, ivy, rubber tree.

Does that make sense?

 

[Joseph Meehan]

I've tried to understand how to do this via the other posts but I
need to use my own data to understand.
I would like fields in a form to automatically populate when choosing
from a drop down menu.
So if x then several values will populate several fields. Ex: if
flower then rose, daisy, petunia OR if plant then rose, ivy, rubber
tree.

Does that make sense?

Do you mean to display the data or to save the data?

 

[John W. Vinson]

I've tried to understand how to do this via the other posts but I need to use
my own data to understand.
I would like fields in a form to automatically populate when choosing from a
drop down menu.
So if x then several values will populate several fields. Ex: if flower
then rose, daisy, petunia OR if plant then rose, ivy, rubber tree.

Does that make sense?

Not really.

Suppose you had 331,874 species of plants in your table. Would you
want 331,874 textboxes filled when you select "plant"?

What exactly are you trying to populate? What is the Recordsource of
your form? How do you determine what should fill the form?

John W. Vinson [MVP]