The "Bound Column" has nothing to do with the widths of the columns. There is a Bound Column property. The value displayed when the combo box isn't dropped down, is the first non-zero width column.
The Control Source of the combo box determines which field in the Record Source of the form will save the selected value.
Tables/fields should not be confused with controls. I never define a field in a table as a combo box/lookup field.
Duane Hookom
MS Access MVP
--- In MS_Access_Professionals@yahoogroups.com, "paulc8481" <paulc8481@...> wrote:
>
> Hello,
> I am working on small database for work and I need some clarity on how to use a bound control. Heres my question.
>
> If I have one table with 6 columns(all Text box controls) and a second table with a combo box control, how do I "bind a column from the first table. Given the tables are properly connected I get confused on the bound column, Column widths, column count.
>
> If I use the column count of 6, with column widths of 0,1,1,0,0,1; Is the first NON 0 column, concidered bound column 1 and the second NON 0 column concidered bound column 2, and the last NON 0 column concidered bound column 5? I just want to get the navigation correct.
>
> Also Is the bound column going to be the data that will be presented in any reports that I will need to produce?
>
> Thanks
>
> Paul
>
Tidak ada komentar:
Posting Komentar