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]
inserting values from lookup table based on a combo box entry 
