I am setting up a database of businesses that I want to be seperated by category name. I have two tables, tblName and tblCategory. The two tables are linked through CatID field. I have created a query to pull Name info and the corresponding Category for my form, frmBusiness. In frmBusiness I would like to have a combo box that list the values in tblCategory, and updates the record automatically. I have tried setting the control source to the query name of the field i am trying to update while the row source was set to qryCategory (which only pulls up Category names). When I do this I am unable to make a selection.
I have also tried to set an afterUpdate event of =[tblCategory]![CategoryName] which gives me an error message when I choose the field.
I'm sure this has been asked 1000 times, I just can't figure out how to search for what I am looking for. Thanks in advance for any help you might be able to give me.