I need help! I'm not sure if this is something better done at the table or form level. I've tried both and I'm hitting a brick wall.

I'm creating a new database and I need to set it up so that the choices available to enter in one field are dependant on what you entered in the previous field.

Is there some way to set that up using the look up wizard function in the tables, or would it be better to set that up when creating a combo box on the form? I have a feeling I'm going to have to go the VBA route and that will be new territory for me.

Any suggestions would be greatly appreciated. I'm going crazy here!!!:confused:

It sounds like you want cascading combo boxes (one dependent on another). Do a search on that and you should find all the info you want.