Parameter Query From Combo On Form

  • Thread starter Thread starter Bill Foley
  • Start date Start date
B

Bill Foley

Heavy drinking is about to set in! :-}

I have a parameter query that I have been typing in a Criteria ("Like [Enter
Name] & *"). Works fine. Getting tired of folks not knowing how to type so
I am building a form (frmSelectname) that is opened with an unbound combo
box that pulls data from a table, giving the user a name to select. The
unbound control's name is "cboName". I have a command button that runs the
query I want run. The Criteria of the field in question of the query says:
"[Forms]![frmSelectName]![cboName]".

It is returning no records! WAH! What am I missing (besides the boat)!

TIA!

Bill
 
It sounds like your query is searching for a person's name?

If this is correct, check the row source of your combo box. It will probably
have two fields in it, usually the primary key field & the text field.

Either change your query to search the primary key field that is associated
with the person selected (which is the best solution), or delete the primary
key field in your combo box so that it only returns the text field.

Hope this helps.
 
What a dufus! I didn't even think to check and see which column was the
bound column! THANKS!

Bill


ihatepaperwork said:
It sounds like your query is searching for a person's name?

If this is correct, check the row source of your combo box. It will probably
have two fields in it, usually the primary key field & the text field.

Either change your query to search the primary key field that is associated
with the person selected (which is the best solution), or delete the primary
key field in your combo box so that it only returns the text field.

Hope this helps.


Bill Foley said:
Heavy drinking is about to set in! :-}

I have a parameter query that I have been typing in a Criteria ("Like [Enter
Name] & *"). Works fine. Getting tired of folks not knowing how to type so
I am building a form (frmSelectname) that is opened with an unbound combo
box that pulls data from a table, giving the user a name to select. The
unbound control's name is "cboName". I have a command button that runs the
query I want run. The Criteria of the field in question of the query says:
"[Forms]![frmSelectName]![cboName]".

It is returning no records! WAH! What am I missing (besides the boat)!

TIA!

Bill
Click to expand...
Click to expand...
 
Back
Top