Click to See Complete Forum and Search --> : Access error 3101


Neuromancer93
February 21st, 2003, 01:27 PM
I'm using Access 2000 and I have 1 form which includes a subform. My main is linked to a table called Customer Names and my subform is linked to a table called Customer Sites. Whenever I use my main form to add a Customer when I try to click in my subform I get this error :

The Microsoft Jet database engine cannot find a record in the table <name> with key matching field(s) <name>. (Error 3101)



The weird thing is that the information gets saved to my tables in both tables but in order to continu using my form I need to restart the program. I've checked on a technet cd, on MSDN, on microsoft web support and in Access 2000 help application but I couldn't find anything about that error.

danprinz
February 27th, 2003, 11:17 AM
try refresh or reload the subform query after editing the mainform.

Neuromancer93
March 4th, 2003, 11:08 AM
Sorry but apparently the answer is more complicated than that. I've gone around it.

Thanks anyway,
Neuromancer93

radofan
June 1st, 2006, 05:42 AM
so what was the solution?

thanks