Combo Box

  • Thread starter Thread starter Eddie Jackson
  • Start date Start date
E

Eddie Jackson

On a new Form I have put a Combo box which gets its list of contents from a
table.
I guessed that by putting [Forms]![ClassesDir]![Combo14] into the Query
Builder that when I made a selection from the Combo Box it would invoke the
Query, alas not.

However when I run the query and put the figure in manually the Query works.
But I want the input to come from the Combo Box.
Any help would be welcome
Regards
Eddie
 
Force a Requery in the AfterUpdate event of the ComboBox.

On a new Form I have put a Combo box which gets its list of contents from a
table.
I guessed that by putting [Forms]![ClassesDir]![Combo14] into the Query
Builder that when I made a selection from the Combo Box it would invoke the
Query, alas not.

However when I run the query and put the figure in manually the Query works.
But I want the input to come from the Combo Box.
Any help would be welcome
Regards
Eddie
Click to expand...

_______________________________________________
hth - RuralGuy (RG for short)
Please post to the NewsGroup so all may benefit.
 
All ready tried that with no joy
Eddie
Force a Requery in the AfterUpdate event of the ComboBox.

On a new Form I have put a Combo box which gets its list of contents from
a
table.
I guessed that by putting [Forms]![ClassesDir]![Combo14] into the Query
Builder that when I made a selection from the Combo Box it would invoke
the
Query, alas not.

However when I run the query and put the figure in manually the Query
works.
But I want the input to come from the Combo Box.
Any help would be welcome
Regards
Eddie
Click to expand...

_______________________________________________
hth - RuralGuy (RG for short)
Please post to the NewsGroup so all may benefit.
Click to expand...
 
Eddie

Any chance your database uses a lookup data type in one of the fields
involved in this issue? If so, check the tablesdbdesign newsgroup for a
STRONG consensus against using that data type -- it stores one value, but
displays something else, making for confusing combo boxes, list boxes and
queries.
 
Is the form on which the ComboBox resides bound to the query of which you spoke?
If so then Me.requery *will* for the form to run the query again. You may need
to use the Column property of the ComboBox to get the value you desire.
Forms![ClassesDir]![Combo14].Column(0)

This is a zero based index so Column(1) would be the 2nd column. It need not be
visible.

All ready tried that with no joy
Eddie
Force a Requery in the AfterUpdate event of the ComboBox.

On a new Form I have put a Combo box which gets its list of contents from
a
table.
I guessed that by putting [Forms]![ClassesDir]![Combo14] into the Query
Builder that when I made a selection from the Combo Box it would invoke
the
Query, alas not.

However when I run the query and put the figure in manually the Query
works.
But I want the input to come from the Combo Box.
Any help would be welcome
Regards
Eddie
Click to expand...

_______________________________________________
hth - RuralGuy (RG for short)
Please post to the NewsGroup so all may benefit.
Click to expand...
Click to expand...

_______________________________________________
hth - RuralGuy (RG for short)
Please post to the NewsGroup so all may benefit.
 
Many thanks for the replies it's amazing how 3 days grafting for a solution
culminates in a few seconds work. I deleted the lookups in the tables which
when I thought about it were not being used in any of my forms, at the same
time I checked on which values were being used in the Combo Box and now I
have the result I was after.
Many thanks (till next time)
Eddie
 
Back
Top