Hi hope you can help,
I’m creating a catalogue with MS Access. On the main form I have a list box with all the names of the package and a subform that has all the details of that package.
At the moment if I use the navigation buttons to view each package and then click on an item in the subform, the form I want pops up on the record I require.
What I would like to do is NOT use the navigation buttons and to be able to just click on the package to display all the details of the package.
At the moment all that works, the problem arises when I click on the item in the subform the message “The changes you requested to the table were not successful because they would create duplicate values in the index, primary key, or relationship. Change the data in the field or fields that contain duplicate data, remove the index, or redefine the index to permit duplicate entries, and try again.” comes up.
I understand what the message is telling me but I don’t want to make changes to the table, I just want to view the information in pop up form that will then allow me to make changes IF that’s what I want to do.
It's not the navigation buttons that are the problem, it's the fact that i don't want to use the navigation buttons to go through all the packages to find the one I want, I just want to click on the package I'm looking for, then click on the item I want to pop up as new form. All this works when I use the navigation buttons, not when I just click on the desired package.
So you have to set up an unbound listbox with all your packages and an After Update event procedure that does a FIND operation that uses the unbound listbox to find the package by navigating to it.... I think!