RE: Combo box storing wrong field

No-When I put in your column widths, I only see the second column in the drop
down list. I need to see all three columns, then when I choose, only see the
second displayed. Is that possible?
--
Darc


"KARL DEWEY" wrote:

I do want them all to display until I click on them, then only want column
two to show while the user is choosing other pieces of equipment in the 7
other combo boxes.
You did not state whether what I posted work for you or not.

how do I have it run only on the combo boxes that have been clicked?
You will need to post again as I have not worked with multi-select combos.
--
KARL DEWEY
Build a little - Test a little


"Broadbonian" wrote:

I do want them all to display until I click on them, then only want column
two to show while the user is choosing other pieces of equipment in the 7
other combo boxes. Another issue, when they are done filling in form, a macro
run the make table qry on all combo boxes, how do I have it run only on the
combo boxes that have been clicked? Otherwise I get rows of data with only
the dates in them.
--
Darc


"KARL DEWEY" wrote:

Column Widths --
0"; 1.5"; 0"
--
KARL DEWEY
Build a little - Test a little


"Broadbonian" wrote:

Hi Karl, Thanks for the help. I got a little further. I do want to display
all 3 columns in my form, which it does, until click on the row I want. Then
it only displays the first column. I want it to display the second column
info. It does store the second column info when I do the make table query,
so that works now. Can you help with the display?
--
Darc


"KARL DEWEY" wrote:

but when I choose it only stores the 1st column, even though the bound
column is #3.
Open form in design view, click on the combo and look at the property Column
Widths. This property sets the display widths in inches. If it shows 0";
0"; 1.5" or some such it will not display columns 1 and 2. Normally you only
want to display one column.
--
KARL DEWEY
Build a little - Test a little


"Broadbonian" wrote:

Access 2003
Not sure if using right approach. 3 tables:Job, Employee, Equipment, Trucks.
I have a form-Schedule that uses the table Job. The user chooses a job, a
date range, the uses combo boxes to choose Employee, Equipment, Trucks. They
can choose up to 9 rows per combo box. Then I want to use an append qry to
create the "schedule" for that time period. The user needs to be able to go
back in the form and change the schedule if necessary. Am I on the right
track? I can get the combo boxes to display all their fields, but when I
choose it only stores the 1st column, even though the bound column is #3.
The control is bound to a field in the Job table. What am I doing wrong? Is
this the correct approach to this database?
Thanks for any help
Darc
.

Relevant Pages

  • RE: Combo box storing wrong field
    ... stores the information. ... It will only display one. ... "KARL DEWEY" wrote: ... other combo boxes. ...
    (microsoft.public.access.gettingstarted)
  • RE: Combo box storing wrong field
    ... The combo boxes are not bound. ... "KARL DEWEY" wrote: ... First, a combo box does not store information, the field it is bound to ... It will only display one. ...
    (microsoft.public.access.gettingstarted)
  • RE: Combo box storing wrong field
    ... other combo boxes. ... "Broadbonian" wrote: ... "KARL DEWEY" wrote: ... I want it to display the second column ...
    (microsoft.public.access.gettingstarted)
  • RE: Combo box storing wrong field
    ... I do want them all to display until I click on them, ... other combo boxes. ... "KARL DEWEY" wrote: ... tables:Job, Employee, Equipment, Trucks. ...
    (microsoft.public.access.gettingstarted)
  • Re: Fill Text Caption with Value
    ... which will display Bob when a new record is entered. ... Value is 'Bob' and not the '2'. ... I would like to show the second column ... the first column, ...
    (microsoft.public.access.formscoding)