there is a report associated with this. the manager want users to be able to just type in a code and by the code they pick the two combo boxes will automatically have the category and services associated with that code. so if they pick. I got some help with this before http://www.dbforums.com/microsoft-ac...ml#post6428070
Was wondering do I add a combo box named TanfCodes, should I use that for the users to choose from then have it populated the other two combo boxes which are named [servicescovered] and [category]
My question is why do you need three combo boxes when MERCodes combo box contains unique records e.g. 1a, 1b,1c,1d,1e? Now, if you have more than 1 Mercodes e.g. more than 1a codes with different values in Category and Services then you will need additional combo boxes.
You can also populate text boxes using the same method for Category and Services.