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

Auto fill text box with lookup data

P: n/a
Jim
I've designed a wine inventory tracking & winelist printing program.

When entering a wine I always have to place the wine under a heading
on the winelist. Usally, a wine ends up under the heading that
represernts a variety. chardonny would fall under chardonnay, Merlot
under merlot... But in some instances (less then 5%) I want to force
a wine into a diferent catagory... say a 5 liter bottle of Merlot I
want under a big bottle heading instead of merlot.

Assuming I have a table of likely headings:

Varietal Likely heading

Chardonny Chardonnay
Sangiovesse Italian Reds
Merlot Merlot
Viogner Rhone Whites
Pinot Noir Pinot Noir
How can I on a form cause the heading text box to update when I select
a Varietal.

I still want to be able to manually change the heading if I desire.

Jim Lamb
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
This may become a problem if the "Varietal" can have more than one "Likely
Heading". Otherwise, look at the DLookUp function and the AfterUpdate event.

Mike Storr
www.veraccess.com
"Jim" <go****@whatifcomputers.com> wrote in message
news:39**************************@posting.google.c om...
I've designed a wine inventory tracking & winelist printing program.

When entering a wine I always have to place the wine under a heading
on the winelist. Usally, a wine ends up under the heading that
represernts a variety. chardonny would fall under chardonnay, Merlot
under merlot... But in some instances (less then 5%) I want to force
a wine into a diferent catagory... say a 5 liter bottle of Merlot I
want under a big bottle heading instead of merlot.

Assuming I have a table of likely headings:

Varietal Likely heading

Chardonny Chardonnay
Sangiovesse Italian Reds
Merlot Merlot
Viogner Rhone Whites
Pinot Noir Pinot Noir
How can I on a form cause the heading text box to update when I select
a Varietal.

I still want to be able to manually change the heading if I desire.

Jim Lamb

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.