Access 2010 - BoundColumn Not Available - Other Options? 1

[tqeonline]

Hi All!

I am using the Non-Profit Form / Template that comes out of the box with Access. I have copied the Donors table and created a "Rotarians" table to be able to link a Rotarian/Sponsor to the Donors.

I then added a combo box on the DonorDetails form that is a dropdown of the ID and FileAs (name) of the Rotarian and it updates a field on the Donors Table called "Rotarian ID" which is the foreign key to the Donors table.

My issue is that "BoundColumn" does not show up as an option. I'd like for only the names (FileAs) to show in the drop down but in the update/databinding to update the ID in Rotarian ID.

Right now when you first visit the form it simply just shows the "ID" and you have to click on the drop down to see who the matching Rotarian is.

- Matt

"If I must boast, I will boast of the things that show my weakness"

- Windows 2003 Server, 98 SE, XP
- VB.NET, VSTS 2010, ASP.NET, EXCEL VBA, ACCESS, SQL 2008

 

[PHV]

Set the width of the 1rst column to zero.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[tqeonline]

I hate easy solutions... I searched for a good hour and couldn't find that.

- Matt

"If I must boast, I will boast of the things that show my weakness