Office Software Thread, Access - Combo Box not populating table in Technical; I have two identical tables (A & B), populated by two identical forms.
A) I select an asset category from ...
5th November 2013, 12:51 PM #1
Access - Combo Box not populating table
I have two identical tables (A & B), populated by two identical forms.
A) I select an asset category from a combobox populated from another table (two columns, one bound) click save and it populates the table with the selection.
B) I select an asset category from a combobox populated from another table (two columns, one bound) click save and it errors with "You must enter a value in 'Assets.AssetCategory' field.
Both use the following to populate -
Why would one work and the other not?
SELECT DISTINCTROW [Asset Categories].*
FROM [Asset Categories]
ORDER BY [Asset Categories].AssetCategory;
5th November 2013, 02:44 PM #2
If I change the Control source of table B's combobox to the non-linked source it works, but it changes the wrong info.
I realise my table has a few quirks, like the primary key and its secondary value in the same table instead of it being joined.
work to do.
5th November 2013, 02:54 PM #3
So, why would it refuse to populate the correct entry in the table?
I need it to work as its breaking other things.
By tony82 in forum Wireless Networks
Last Post: 10th March 2010, 10:11 AM
By Shrimpersfan in forum Coding
Last Post: 23rd December 2008, 07:38 PM
By speckytecky in forum General Chat
Last Post: 16th December 2008, 10:41 AM
By Frazer in forum Windows
Last Post: 20th October 2005, 12:03 PM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)