Bladerunner
Registered User.
- Local time
- Yesterday, 16:22
- Joined
- Feb 11, 2013
- Messages
- 1,792
Do not know if this is a query or a form problem!
I use a form that calls up the Animal_ID (text field) from a query that filters the records from a table named 'tblAnimal Setup' and displays it within a list box (for an Animal ID text field ) on another form thus allowing the user to pick the animal they need for that particular purpose. Within the 'TblAnimal Setup' there are three fields that determine which 'Animal ID' can be used in the other forms. The 'Animal ID's' presented in the list boxes on these other forms come from a query that uses the three fields to determine which ones are allowed to be used.
Let say I want only animals that are 'Dogs' and those dogs that have not been sold or have died. My Query works fine, but how can I get the results of the query (Animal ID) from 'tblanimal setup' to appear in the list box on other forms? I have tried several things but nothing as of yet works. Thanks
Have a nice day
Bladerunner
I use a form that calls up the Animal_ID (text field) from a query that filters the records from a table named 'tblAnimal Setup' and displays it within a list box (for an Animal ID text field ) on another form thus allowing the user to pick the animal they need for that particular purpose. Within the 'TblAnimal Setup' there are three fields that determine which 'Animal ID' can be used in the other forms. The 'Animal ID's' presented in the list boxes on these other forms come from a query that uses the three fields to determine which ones are allowed to be used.
Let say I want only animals that are 'Dogs' and those dogs that have not been sold or have died. My Query works fine, but how can I get the results of the query (Animal ID) from 'tblanimal setup' to appear in the list box on other forms? I have tried several things but nothing as of yet works. Thanks
Have a nice day
Bladerunner
