OK will try again. Have an animal database. Main table = [tblanimal setup],
This main table contains locations, group and of course, 'Animal ID' of each animal among other info. There is one tblLocation and one tblGroup that allows the user to pull them down on locationcbo, groupcbo located of the [navigation form](in the header area).
On a [navigation form], at the top, I have three cbos. one for location, one for group and one for the animal ID. Keep in mind these are not cascading. locationcbo and groupcbo can be empty. (default, null = All). p.s. (default, null in [animalDcbo] chooses no IDs thus any forms pulled up will be empty)
what I am trying to do is pull up the animals IDs in the third (animalIDcbo), by using a query that looks possibly at the 'afterchange' value of Location and Group. It then looks to the main table [tblanimal setup], pulls up the animals that are in those locations and groups (does not matter what order). After the animal has been chosen, that (number or name) will be used to pull up data in various other forms (one at a time) on the navigation form. An Example, (IF [locationcbo] ="main pasture"', [Groupcbo] ="Nursery" then [AnimalIDcbo] will list 12 animals in the [animalIDcbo] drop down box.Now lets say the chosen [animal ID] from [AnimalIDcbo] = (5784B). The Health tab on [navigation form] is clicked and the last information of the healthrecord for (5784B) appears on the Health Form (captured from [tblhealthrecords]). At this point new info can be added to this table via new healthrecord.
Just cannot get it to give me the animalID in the third combo. Should be able to use one maybe two queries since they are not cascading. have tried using: [forms]![Navigation Form]![groupcbo] in the query design-view to pull up the IDs. (testing only on groups but location should be close to the same.)
Trying to keep the number of queries down here.
The combinations would be to staggering to write a query for each. I have 14 locations and there are about 6-8 groups and that is small to what some people will ave.
Everything else is almost done except making it pretty. I had been using a switch board. It does work but when I pull up inventory, it pulls up 'all' animals. Not acceptable.
Hope this helps. No much on language of Access.