I have 2 tables Monitor and Mileage. Created Form and subform to use combo box to show mileage for one particular monitor. Works fine. When I open the form the form shows the combobox, allows me to choose which monitor and then show only that monitors mileage.
Problem comes when I attempt to add new mileage to that monitor I get following message "The Microsoft Jet database engine cannot find a record in the table 'Monitor' with key matching field(s) 'Mileage.MonitorId" (Error 3101)" How do I set the value for the "Mileage.MonitorId" to be the same as the combo box?