Simple Search

  • Thread starter jjsaw5 via AccessMonster.com
  • Start date
J

jjsaw5 via AccessMonster.com

I've posted about this before but I think i may have been confusing in what i
was asking.

I have a table with a Primary Key TC NUM. The users of my database would like
to be able to search the records by this number.

I currently have a form with a combo box search in the hearder that pulls up
the information in the body of the form. The users would like to see the
combo box replaced with a Text box with a button they can press to execute
their search.

I'm not really sure how to code this so any help would be great.
 
R

Rick Brandt

jjsaw5 said:
I've posted about this before but I think i may have been confusing
in what i was asking.

I have a table with a Primary Key TC NUM. The users of my database
would like to be able to search the records by this number.

I currently have a form with a combo box search in the hearder that
pulls up the information in the body of the form. The users would
like to see the combo box replaced with a Text box with a button they
can press to execute their search.

I'm not really sure how to code this so any help would be great.
Click to expand...

Move the code currently in the AfterUpdate of the ComboBox to the Click
event of the Button. Then change the ComboBox to a TextBox by using (from
the menu) Format - Change To - TextBox. Since the name of the control
referenced in the code will be the same you shouldn't have to change
anything else.
 
J

jjsaw5 via AccessMonster.com

Awsome! Thank you! I will give it a shot.

Rick said:
I've posted about this before but I think i may have been confusing
in what i was asking.
Click to expand...
[quoted text clipped - 8 lines]
I'm not really sure how to code this so any help would be great.
Click to expand...

Move the code currently in the AfterUpdate of the ComboBox to the Click
event of the Button. Then change the ComboBox to a TextBox by using (from
the menu) Format - Change To - TextBox. Since the name of the control
referenced in the code will be the same you shouldn't have to change
anything else.
Click to expand...
 
Top