Hi
I have attached an extract from my database to show the challenge I am having and would be really grateful for help with the final part as I have searched these forums for many hours and adapted my database using the guidance therein but am getting stuck at the final hurdle.
Basically I have a form (searchform) which allows users to search for a supplier name and the result is then shown in the list box above . This part works fine but when I double click on the correct supplier name, I get an error message (run time 2501). What I want to happen is for the form called frm AV production to open at the correct record.
For example, if Fred Bloggs Ltd had been selected as the supplier to find, then I want frm AV production to open at the correct record (Fred Bloggs Ltd) to allow changes to be made eg name change to Freda.
I thank you in advance for your help.
I have attached an extract from my database to show the challenge I am having and would be really grateful for help with the final part as I have searched these forums for many hours and adapted my database using the guidance therein but am getting stuck at the final hurdle.
Basically I have a form (searchform) which allows users to search for a supplier name and the result is then shown in the list box above . This part works fine but when I double click on the correct supplier name, I get an error message (run time 2501). What I want to happen is for the form called frm AV production to open at the correct record.
For example, if Fred Bloggs Ltd had been selected as the supplier to find, then I want frm AV production to open at the correct record (Fred Bloggs Ltd) to allow changes to be made eg name change to Freda.
I thank you in advance for your help.
Last edited: