Ok..that worked..thanks...one last thing..how do you get the combobox to show only one column when you make a selection from it, instead of all three?
Access Newbie
Novice
Windows XP 
Access 2010 32bit
Ok..that worked..thanks...one last thing..how do you get the combobox to show only one column when you make a selection from it, instead of all three?
Competent Performer
Windows 7 64bit Access 2007
actually, i think you need to show the columns that you need.
in other words, if you need to populate 3 boxes, you need to show those three columns.
i'm not sure if there is another way around this.
Competent Performer
Windows 7 64bit Access 2007
no problem, im glad I helped; don't forget to mark the thread as solved
Novice
Windows XP Access 2010 32bit
I actually figured out how to show only 1 column in the combobox. I adjusted the column widths in the format tab of properties. It was showing 0;"1". I changed it to 0;"2" and then I pulled the edge of the combobox to only show the first column. I am not sure why that worked but it is only showing the first column and it still populates the three boxes and writes to the table when I click the add data button.
Just thought you might like to know for your database design.
Posting Permissions
Reply With Quote