I have a user form that is for entering in candidate profiles. There is a tab control with 4 tabs. Each tab has a subform, 1 subform has a subform within it. Each subform has 1 or 2 combo boxes, which are FK's to type or listing tables.
What I want to do is prevent a user from being able to type in the combo at all. I want it to give them a message if they do type in a combo, ( I know you can have the combo just go down the list based on the letters typed, and that is ok. Again not sure how to do this) that it isn't in the list, and to please use the button on the left to maintain that type. It would be an OK message. Does that sound right? I figure I can also put a simple requery on the combo's onclick so that the combo always shows the newest data.
Can anyone help me out?
These combo's are not all one field.
For example, One subform is for address. This has a combo for address type, which is just one field.
Then there is a city, state zip combo. This goes to the city table (tblcity) which has an fk (combo) to the state. The state table is fully maintained. It has all 50 whatever states in it. Anyway, because of this, I would rather direct the users to get in the habit of maintaining types before adding anything else to the subform.
If they don't, it won't let them go on. It throws yucky Access errors about needing that field, and if the type or listing isn't there, they lose the record they are on, because the type has to be maintained. I say that they lose the record, because you have to escape out of the record to be able to maintain the type, and then when you come back, you have to enter in that subform's information all over again.
Grr.
I don't want my users to feel like they have to do all of this work, but it is as simple as if the type is not there, maintain the list and go back. Do not enter anything in until the list is up to date. 
Can anyone help with the control of this aspect?
Thank you.
What I want to do is prevent a user from being able to type in the combo at all. I want it to give them a message if they do type in a combo, ( I know you can have the combo just go down the list based on the letters typed, and that is ok. Again not sure how to do this) that it isn't in the list, and to please use the button on the left to maintain that type. It would be an OK message. Does that sound right? I figure I can also put a simple requery on the combo's onclick so that the combo always shows the newest data.
Can anyone help me out?
These combo's are not all one field.For example, One subform is for address. This has a combo for address type, which is just one field.
Then there is a city, state zip combo. This goes to the city table (tblcity) which has an fk (combo) to the state. The state table is fully maintained. It has all 50 whatever states in it. Anyway, because of this, I would rather direct the users to get in the habit of maintaining types before adding anything else to the subform.
If they don't, it won't let them go on. It throws yucky Access errors about needing that field, and if the type or listing isn't there, they lose the record they are on, because the type has to be maintained. I say that they lose the record, because you have to escape out of the record to be able to maintain the type, and then when you come back, you have to enter in that subform's information all over again.
Grr.
I don't want my users to feel like they have to do all of this work, but it is as simple as if the type is not there, maintain the list and go back. Do not enter anything in until the list is up to date. Can anyone help with the control of this aspect?
Thank you.
