By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,652 Members | 1,409 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,652 IT Pros & Developers. It's quick & easy.

inserting values from lookup table based on a combo box entry

P: n/a
I'm missing something really simple, I'm sure. I have a form to be
filled in. The operator choosed a plant species (the botanical name)
from a list in a combo box. (The lookup table is populated with
botanical name, common name, size, and price.) Based on their choice,
I would like the other 3 fields filled in from the lookup table. The
resulting date should be written to the base table which will be a
record of the plants ordered, their size, the price, and the quantity.

I can choose the lookup value with no problem, but darned if I can get
the rest of the form to fill in based on that value! So what am I
missing?

Art
Nov 12 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
Your combobox row source should look like:
PlantID
PlantSpecie
BotanicalName
Commonname
Size
Price

Bound Column set for 1, ColumnCount set for 6, Column Width set for 0;2;0;0;0;0

Put the following code in the Afterupdate event of the combobox:
Me!txtBotanicalName = Me!NameOfComboBox.Column(2)
Me!txtCommonName = Me!NameOfComboBox.Column(3)
Me!txtSize = Me!NameOfComboBox.Column(4)
Me!txtPrice = Me!NameOfComboBox.Column(5)
--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdatasheet.com
www.pcdatasheet.com

"Art at ABE Computer Consultants" <ar*************@abeconsultants.com> wrote in
message news:a9**************************@posting.google.c om...
I'm missing something really simple, I'm sure. I have a form to be
filled in. The operator choosed a plant species (the botanical name)
from a list in a combo box. (The lookup table is populated with
botanical name, common name, size, and price.) Based on their choice,
I would like the other 3 fields filled in from the lookup table. The
resulting date should be written to the base table which will be a
record of the plants ordered, their size, the price, and the quantity.

I can choose the lookup value with no problem, but darned if I can get
the rest of the form to fill in based on that value! So what am I
missing?

Art

Nov 12 '05 #2

P: n/a
Thanks, I'll give it a try.
BTW--if you remember, I was the one who helped you a bit with your web
site--have you ever resolved it? That was maybe 2 years ag.

Art

"PC Datasheet" <sp**@nospam.spam> wrote in message news:<JJ******************@newsread2.news.atl.eart hlink.net>...
Your combobox row source should look like:
PlantID
PlantSpecie
BotanicalName
Commonname
Size
Price

Bound Column set for 1, ColumnCount set for 6, Column Width set for 0;2;0;0;0;0

Put the following code in the Afterupdate event of the combobox:
Me!txtBotanicalName = Me!NameOfComboBox.Column(2)
Me!txtCommonName = Me!NameOfComboBox.Column(3)
Me!txtSize = Me!NameOfComboBox.Column(4)
Me!txtPrice = Me!NameOfComboBox.Column(5)
--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdatasheet.com
www.pcdatasheet.com

"Art at ABE Computer Consultants" <ar*************@abeconsultants.com> wrote in
message news:a9**************************@posting.google.c om...
I'm missing something really simple, I'm sure. I have a form to be
filled in. The operator choosed a plant species (the botanical name)
from a list in a combo box. (The lookup table is populated with
botanical name, common name, size, and price.) Based on their choice,
I would like the other 3 fields filled in from the lookup table. The
resulting date should be written to the base table which will be a
record of the plants ordered, their size, the price, and the quantity.

I can choose the lookup value with no problem, but darned if I can get
the rest of the form to fill in based on that value! So what am I
missing?

Art

Nov 12 '05 #3

P: n/a
No! I still have a webform/submit that doesn't work.

Steve
"Art at ABE Computer Consultants" <ar*************@abeconsultants.com> wrote in
message news:a9**************************@posting.google.c om...
Thanks, I'll give it a try.
BTW--if you remember, I was the one who helped you a bit with your web
site--have you ever resolved it? That was maybe 2 years ag.

Art

"PC Datasheet" <sp**@nospam.spam> wrote in message

news:<JJ******************@newsread2.news.atl.eart hlink.net>...
Your combobox row source should look like:
PlantID
PlantSpecie
BotanicalName
Commonname
Size
Price

Bound Column set for 1, ColumnCount set for 6, Column Width set for 0;2;0;0;0;0
Put the following code in the Afterupdate event of the combobox:
Me!txtBotanicalName = Me!NameOfComboBox.Column(2)
Me!txtCommonName = Me!NameOfComboBox.Column(3)
Me!txtSize = Me!NameOfComboBox.Column(4)
Me!txtPrice = Me!NameOfComboBox.Column(5)
--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdatasheet.com
www.pcdatasheet.com

"Art at ABE Computer Consultants" <ar*************@abeconsultants.com> wrote in message news:a9**************************@posting.google.c om...
I'm missing something really simple, I'm sure. I have a form to be
filled in. The operator choosed a plant species (the botanical name)
from a list in a combo box. (The lookup table is populated with
botanical name, common name, size, and price.) Based on their choice,
I would like the other 3 fields filled in from the lookup table. The
resulting date should be written to the base table which will be a
record of the plants ordered, their size, the price, and the quantity.

I can choose the lookup value with no problem, but darned if I can get
the rest of the form to fill in based on that value! So what am I
missing?

Art

Nov 12 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.