Autofill fields by selecting a record in a combo box

  • Thread starter Art at ABE Computer Consultants
  • Start date
A

Art at ABE Computer Consultants

I have a subform that has several fields. For instance, "scientific
name," "common name," "size," and "cost" These refer to plants used
in quoting a landscaping job. All this data is found in a lookup
table, but there are lots of plants. So--with a combo box that looks
up the "scientific name", I wish to bring in the other 3 fields to the
form after choosing the correct name. I can then add a "quantity" and
do some math and get the total cost for each plant.

For the life of me, I can't remember how to populate the fields after
I do a lookup in the combo box. Does anyone have the answer?

Thanks---Art
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Autofill Combo Form Always Selects First Record If Same Name 6
Combo box assigned to a field not working 1
Using Combo Box selections to automatically populate fields 2
Need my form to retain records selected in Combo boxes 5
synchronize combo boxes 7
Combo Boxes - DISPLAYING multiple fields after choice is made 6
Is what I want called a subform? 1
synchronized Combo Boxes in subforms 2

Top