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
3  2268 
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
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
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
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: James |
last post by:
Hello group:
I've done alot of reading on this subject somewhat and have found that
many people have many different opinions on this subject. My question
centers mainly around using a lookup...
|
by: my-wings |
last post by:
I've been reading about how evil Lookup fields in tables are, but I've got
to be missing something really basic. I know this subject has been covered
before, because I've just spent an hour or two...
|
by: Zachary Turner |
last post by:
I want to make a Lookup Field based on another Lookup field. In other
words, I have this table A with two fields: ID and Name, where ID is
an Autonumber and Name is a friendly name. Then I have a...
|
by: Aaron Ackerman |
last post by:
I have a bound combobox the appears on a cell within the column of my bound
grid when the user clicks on a cell n(In my vb.net WinForm app).
I am trying to allow the adding of an item to that bound...
|
by: northshore |
last post by:
Hello,
I am creating a windows application database. I have a primary table
'Individuals' and a lookup table 'Prefixes.' In the Individuals table,
I have a column 'PrefixID' that references...
|
by: mfaisalwarraich |
last post by:
Hi Experts Around the World. I made a table called mainTable, two fields of this table one is SNO and other is Relation are text data types. SNO and Relation can be any string values. Relation stores...
|
by: Mark |
last post by:
I have a table with a field that uses a combobox to populate values. The
Lookup tab within table design mode is the following:
Display Control Combo Box
Row Source Type ...
|
by: AlexanderDeLarge |
last post by:
Hi!
I got a problem that's driving me crazy and I'm desperately in need of help.
I'll explain my scenario:
I'm doing a database driven site for a band, I got these tables for their discography...
|
by: David Wright |
last post by:
Hello Folks
I am using Microsoft Access 2000
I would be grateful if someone could help me with “Dlookup”. I tried various methods of writing Dlookup and various events to trigger it, none of...
|
by: CloudSolutions |
last post by:
Introduction:
For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
|
by: Faith0G |
last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
|
by: ryjfgjl |
last post by:
In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...
|
by: taylorcarr |
last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
|
by: aa123db |
last post by:
Variable and constants
Use var or let for variables and const fror constants.
Var foo ='bar';
Let foo ='bar';const baz ='bar';
Functions
function $name$ ($parameters$) {
}
...
|
by: ryjfgjl |
last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
| |
