'not on list' combo function

[Kazza]

Hi
I have finally figured out how to do a combo 'not on list' field- perfect now i can scoll down to see all the students names and add new ones. One tiny problem, the students names now do not match with their other details, courses, personal addresses etc. What can i do to keep the 'not on list' function, but also get it to match the students details when i click on a name?
Help please with easy to read answers - new to access :-)

[NeoPa]

If I understand correctly what you're trying to say, then adding entries to a ComboBox which has been disconnected from a close-coupled link with the underlying dataset (essentially by setting the 'Limit To List' property to No), will only add it to the contents of the ComboBox itself and not to the underlying dataset.
It is possible to set up a form with the facility to add records to the underlying dataset, but I don't like using that. It doesn't work very well to my mind (probably doing something wrong).

[Kazza]

If I understand correctly what you're trying to say, then adding entries to a ComboBox which has been disconnected from a close-coupled link with the underlying dataset (essentially by setting the 'Limit To List' property to No), will only add it to the contents of the ComboBox itself and not to the underlying dataset.
It is possible to set up a form with the facility to add records to the underlying dataset, but I don't like using that. It doesn't work very well to my mind (probably doing something wrong).

Thanks for the reply, yes i have done as you state in your comment - ah well, back to the drawing board :-( I thought this may have made thing easier
Cheers anyway
Kazza