I have been building a form to help me register people in classes at my work. When I tested the form, I put in the person's name and in the "processor" drop down combo box, I chose a name and tried to save the form. The first screen shot shows the error message that pops up.
I think the problem has something to do with my relationships...? I posted a second screen shot of the relationships as well. The Processor table and the Individual table are connected.
I do not have any code written for the Processor combo box.
The value for the RowSource property on the combo box is as follows:
SELECT [Processor].[ProcessorID], [Processor].[Processor Name] FROM Processor ORDER BY [Processor Name];