I have a combo box for selecting records in a table. When I do, the underlying table is corrupted in that the entry selected replaces the first entry in the table. Anybody know why or how to prevent this?
Thanks,
Richard
I have a combo box for selecting records in a table. When I do, the underlying table is corrupted in that the entry selected replaces the first entry in the table. Anybody know why or how to prevent this?
Thanks,
Richard
My guess is that the Combobox has a Field in its Control Source Property, which means that it is Bound to a Field in the underlying Table. For doing this kind of thing, the Combobox has to be Unbound! Go to Properties - Data, for the Combobox, and delete the Field from the Control Source Property.
Linq ;0)>
The problem with making anything foolproof...is that fools are so darn ingenious!
All posts/responses based on Access 2003/2007
You are exactly right. I had solved that problem somewhere else and forgot about it.
Thanks much.
You're quite welcome! It's a common problem, which is how I knew what you'd done! And, of course, you're more likely to remember the solution the next time around!
Good luck with your project!
Linq ;0)>
The problem with making anything foolproof...is that fools are so darn ingenious!
All posts/responses based on Access 2003/2007