Quick Auto-Filter Question

[ScherzoVivo]

Hi Everyone!

I work at a hotel and have a workbook in which we're going to be logging guest issues. I've pieced together code from various example workbooks and the data input user form is actually working surprisingly well (especially since I'm pretty rusty on the programming end of things).

Anyway, my problem comes up when I try to use a textbox embedded within the main data sheet. The workbook I "stole" it from was able to type something into the box and have the results filtered in real time based on that input. However, after I added additional columns into that sheet, the filter is now being applied to the incorrect column and I just cannot find the issue for the life of me. (I hope that made some kind of sense.) Additionally, it seems to be hiding any data with numbers in Column B for some reason...

Basically what I'm asking is, in the workbook I've attached, how do I get the textbox to filter data in Column C instead of Column B?

[jindon]

Try change

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

[ScherzoVivo]

Still trying to sort by Column B for some reason.

[SjonR]

change the field number to 3

Please Login or Register  to view this content.

It's hiding numeric values, because it isn't text. Place an ' in front of the numbers to make them text.

[ScherzoVivo]

Here, I've included a more "realistic" list of data.

[jindon]

Ahh, Then Field := 3

[ScherzoVivo]

YOU ARE A MAGICIAN. Thank you!

[jindon]

Do you mean like this?

Please Login or Register  to view this content.

[ScherzoVivo]

Actually it looks to be working with the previous fix you suggested. WOO-HOO!

While I have your attention, though, is there an easy way to restrict input into the combo boxes on my data entry form? I'd like the only options available to be the ones I've specified.

[ScherzoVivo]

Aaaand I definitely just found the answer to my own question. Sorry!!

[jindon]

So, everything is fine?

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.