I have been a self-taught developer for the past 3 jobs and 20 years but I don't know anything about code. I am currently using Access 2003 and I am having trouble with a Combo Box on a form.
I had a combo box (based on a table), storing the choice in a field in the query and underlying table the form is based on. Everything was working fine, until... I was trying to figure out how to get the combo box to fill in multiple fields based on the choice made in the combo box. I was not able to figure that out and went back to the original combo box but now when you make a choice from the drop down list you get an error bell and nothing happens.
I create forms in design view, not based on any template.
I have other forms with combo boxes that work.
I have deleted the combo bax and recreated it, set the table property for the field to text box, compacted and repaired, created a whole new form and compared the properties of the form that works with the properties of the form that does not work all with the same results every time.
I have tried to find the answer to this almost all day every day at work for the past 8 days.
If anyone can help me, I would greatly appreciate it.
Karen