Combo Box

[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

 

[RuralGuy]

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

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

 

[Eddie Jackson]

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

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

 

[Jeff Boyce]

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.

 

[RuralGuy]

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

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

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

 

[Eddie Jackson]

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