Edit a form that is open

[gazsharpe101]

Hi, I posted a message before relating to a combo box on a form I have that I want to be able to edit fields stored in a table called 'Notes'. There can be numerous notes stored for each case.

When the form loads it brings up a combo box showing all of the notes that have been made for a particular case and when I choose a note that I wish to edit, it updates a textbox with the particular 'NoteID' of the chosen note.

What I then want to happen is for it to fill in the rest of the form with the details of the note that I selected using the 'NoteID' and I can then edit the note.

I have had no luck in making this happen so far.
Any help would be much appreciated.

Thanks.
Gareth.

 

[RuralGuy]

Why not continue your issue on the same thread?

 

[gazsharpe101]

I could have done but it was a separate issue on a form so I thought I would start a new thread.

 

[RuralGuy]

Did you try removing the ControlSource from the ComboBox?