I would like to say hello to all and thanks in advance. I am currently enrolled in Elementary Database and we use Access 2007. We have not gotten into the code, as someone using 2003 suggested to find my solution. I hope this is in the correct place as my issue is on my forms.
Ok so I am working on my final project and I can not figure out how to make my Look up fields from my look up table work properly.
What I have is my LookUp table which has 3 categories:
States (for customer tables and such, has 50 values),
Categories (for payments out, i.e. office supplies, job materials, has 4 values)
and a Yes/No (2 values) so the text is displayed in the drop down.
When you go to enter the info on a form the Categories drop down has all the blank spaces for the remaining States. My issue is I need the blank spaces not to display. Our instructor showed us once how to take care of the problem but it took him like 5 minutes to figure it out himself and I can not remember how to get to the property or setting where ever it is. I know it is right in front of me I just can't find it right now.
Please help
Ok so I am working on my final project and I can not figure out how to make my Look up fields from my look up table work properly.
What I have is my LookUp table which has 3 categories:
States (for customer tables and such, has 50 values),
Categories (for payments out, i.e. office supplies, job materials, has 4 values)
and a Yes/No (2 values) so the text is displayed in the drop down.
When you go to enter the info on a form the Categories drop down has all the blank spaces for the remaining States. My issue is I need the blank spaces not to display. Our instructor showed us once how to take care of the problem but it took him like 5 minutes to figure it out himself and I can not remember how to get to the property or setting where ever it is. I know it is right in front of me I just can't find it right now.
