Combo Box Properties Question (1 Viewer)

AJJJR

Registered User.
Local time
Today, 01:33
Joined
Mar 19, 2018
Messages
56
HI
This sort of relates to a question I just posted named "Wrong Data From Combo Box ," but I think it better to post separately.

I'm wondering how I can see which field of a table the chosen value from the combobox list will be placed in.

Thanks
 

MajP

You've got your good things, and you've got mine.
Local time
Today, 04:33
Joined
May 21, 2018
Messages
8,525
which field of a table the chosen value from the combobox list will be placed in.
That is the controlsource property.
 

theDBguy

I’m here to help
Staff member
Local time
Today, 01:33
Joined
Oct 29, 2018
Messages
21,454
In conjunction with the Bound Column property.
 

MajP

You've got your good things, and you've got mine.
Local time
Today, 04:33
Joined
May 21, 2018
Messages
8,525
In conjunction with the Bound Column property.
An important point, that answers the reverse question
From which column of the combobox will the value be pulled from?
 

vba_php

Forum Troll
Local time
Today, 03:33
Joined
Oct 6, 2019
Messages
2,880
I'm wondering how I can see which field of a table the chosen value from the combobox list will be placed in.
it comes from what both Maj and guy have said. this is what you want to look for:

column_binding.jpg


control_source.jpg
 

AJJJR

Registered User.
Local time
Today, 01:33
Joined
Mar 19, 2018
Messages
56
So, just to be clear. The value in the bound column property will end up in the control source property?
 

vba_php

Forum Troll
Local time
Today, 03:33
Joined
Oct 6, 2019
Messages
2,880
those r 2 different things. but yes, your thinking is right. it's not "technical", but that does not matter. source is very much related to the binding concept.
 

Users who are viewing this thread

Top Bottom