Software

Ask something
Question Locked

Combo Box in Form displays Data, stores different data in Table.

0 helpful
4 replies

by toast

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

This is what I would like to happen.

A combo box in a form, when pulled down, displays the Client Name, but stores the Client ID in the Table.

Attempting a simple database for a friend. Thanks for your help. I am using Access 2007.

4 replies

by toast

...it's bound to the expression Projects.Client_ID.

After following the instructions given by the paragraph in that book, my combo box is displaying the client name correctly, but when I select a client, I get this error.

Again, what I'm trying to do is lookup a list of clients from the Client table, and store the client identification number in the Projects.Client_ID field.

My Row source is
SELECT Clients.Client_ID, Clients.[Client Name]
FROM Clients
ORDER BY Clients.[Client Name]

My Control Source is
=[Projects].[Client_ID]

Bound Column is 1.

This seems like a simple problem with a simple solution, but I just can't seem to figure it out. If I can solve this then I can create many other forms which work exactly like this.

Thanks

by toast

I had to add in the Client_ID field, then bound the combo box to the field, then deleted it afterwards.

Thanks for your help.

This discussion is closed to new replies.