problems opening a sub form

chrisaabb

New member
Local time
Today, 00:08
Joined
Mar 9, 2004
Messages
7
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.
 
Last edited:
Chrisabb!

There is no attached documen.

Krava
 
Sorry - please find attached - really grateful for your help - Thanks
 

Attachments

Hi!

I did a few things:
1) I have changed the data source for your list box- I have added ID field
2) I have changed the Number of columns of list box to 2
3) I have setup column widths to 0;10cm to hide the first column (ID)
4) Then the list box returns the value of ID that is the number, not the string
5) I have added ID field to your form, I have made it dark gray, I have locked it
6) I used a different method to searching with using docmd.FindRecord
7) It works somehow, seems to be

Hope it helps.

Krava
 

Attachments

I cannot thank you enough for your help - this is fantastic. i will work through your responses to see where I have gone wrong. Thanks again.
 

Users who are viewing this thread

Back
Top Bottom