Edit Form

[ddrew]

I have a Form with a listbox which looks for records on the DB, this works fine. The DB fields are locked for security but I want the user to be able to edit the info on a seperate form which I have created. I thought that because I had selected the person from the list box and clicked the Edit button that it would open th new form with that record displayed, but it dosen't it always goea to the first record. Could someone show me/tell me how to correct this. Thank you!

 

[pl456]

not sure how its all setup but is the value in the list box being passed to the sql string? It sounds like it might not be.

 

[skaas]

This is because your combo boxes are not bound correctly

Nothing to do with SQL

I have provided you with a sample with many ways to get around this and the correct way to bind your combo boxes.

I hope you find this useful

http://www.rogersaccesslibrary.com/Access2000Samples/ComboChoosesRecord2k.zip