By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
428,816 Members | 2,151 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 428,816 IT Pros & Developers. It's quick & easy.

'not on list' combo function

P: 6
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 :-)
Oct 26 '06 #1
Share this Question
Share on Google+
2 Replies


NeoPa
Expert Mod 15k+
P: 31,426
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).
Oct 26 '06 #2

P: 6
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
Oct 27 '06 #3

Post your reply

Sign in to post your reply or Sign up for a free account.