Prev: HELP - Selet Statement not working, Run-time error '3075'
Next: Query List
From: mindyB on 4 Dec 2009 15:30
I am trying to sync to combo boxes on a form. It is for plant names which
consist of Genus + Species + Subspecies, basically. I have all my data in a
single table and I want only applicable species to show up for a particular
Genus, for example:
Abies concolor
Abies glauca
Abies alba
Quercus alba
Quercus macrocarpa

Any genus can have many species, some of those species names can exist
within multiple Genus names, I have made to seperate tables with just Genus
and just Species names, I want them to link in the combo boxes, any ideas?
From: Jeff Boyce on 4 Dec 2009 16:49
Previously responded to...

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.

"mindyB" <mindyB(a)discussions.microsoft.com> wrote in message
news:F843BC83-4D89-498B-B975-3FA525DD9488(a)microsoft.com...
>I am trying to sync to combo boxes on a form. It is for plant names which
> consist of Genus + Species + Subspecies, basically. I have all my data in
> a
> single table and I want only applicable species to show up for a
> particular
> Genus, for example:
> Abies concolor
> Abies glauca
> Abies alba
> Quercus alba
> Quercus macrocarpa
>
> Any genus can have many species, some of those species names can exist
> within multiple Genus names, I have made to seperate tables with just
> Genus
> and just Species names, I want them to link in the combo boxes, any ideas?


 | 
Pages: 1
Prev: HELP - Selet Statement not working, Run-time error '3075'
Next: Query List