Connecting Tech Pros Worldwide Help | Site Map

inserting values from lookup table based on a combo box entry

  #1  
Old November 12th, 2005, 11:39 PM
Art at ABE Computer Consultants
Guest
 
Posts: 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
  #2  
Old November 12th, 2005, 11:39 PM
PC Datasheet
Guest
 
Posts: n/a

re: inserting values from lookup table based on a combo box entry


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
resource@pcdatasheet.com
www.pcdatasheet.com



"Art at ABE Computer Consultants" <artgetridofspam@abeconsultants.com> wrote in
message news:a91610cd.0405081915.421995b8@posting.google.c om...[color=blue]
> 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[/color]


  #3  
Old November 12th, 2005, 11:39 PM
Art at ABE Computer Consultants
Guest
 
Posts: n/a

re: inserting values from lookup table based on a combo box entry


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" <spam@nospam.spam> wrote in message news:<JJhnc.10220$8S1.8847@newsread2.news.atl.eart hlink.net>...[color=blue]
> 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
> resource@pcdatasheet.com
> www.pcdatasheet.com
>
>
>
> "Art at ABE Computer Consultants" <artgetridofspam@abeconsultants.com> wrote in
> message news:a91610cd.0405081915.421995b8@posting.google.c om...[color=green]
> > 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[/color][/color]
  #4  
Old November 12th, 2005, 11:39 PM
PC Datasheet
Guest
 
Posts: n/a

re: inserting values from lookup table based on a combo box entry


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

Steve


"Art at ABE Computer Consultants" <artgetridofspam@abeconsultants.com> wrote in
message news:a91610cd.0405090633.20bd3f6a@posting.google.c om...[color=blue]
> 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" <spam@nospam.spam> wrote in message[/color]
news:<JJhnc.10220$8S1.8847@newsread2.news.atl.eart hlink.net>...[color=blue][color=green]
> > 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[/color][/color]
0;2;0;0;0;0[color=blue][color=green]
> >
> > 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
> > resource@pcdatasheet.com
> > www.pcdatasheet.com
> >
> >
> >
> > "Art at ABE Computer Consultants" <artgetridofspam@abeconsultants.com> wrote[/color][/color]
in[color=blue][color=green]
> > message news:a91610cd.0405081915.421995b8@posting.google.c om...[color=darkred]
> > > 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[/color][/color][/color]


Closed Thread