Recent content by rendon115

Looking to generate a report (InfoReport) off of a subform selection in datasheet view. The subform (SearchSUBFORM) datasheet view displays 4 columns of information stored in a larger table (TagJunction). TagJunction has around 12 columns of information in it, that arent all displayed in...

Thank you for your help, that's exactly what I needed. I also found out I have to set the .GetFocus on the textbox first to get the values of of the SearchBox without it throwing a fit.

I had to drop the .Me on everything here, and now Im getting a run-time error '424' on this line: strCriteria = "[MNumber] like '*" & SearchBox.Text & "*'" On a semirelated note, while calling this function, do I need to specify exact locations for everything involved? Such as...

Relatively simple, I have a Subform in datasheet view that currently takes in filters from both a Textbox entry, and a MultiSelect Listbox. It filters just fine, based on both of those entries/selections. But it only filters either the Textbox, or the Listbox, but not both. What I would like it...

Once again, thank you. Now I checked it completely (So I dont have to bother you again) and it works perfectly. Thanks again

Well consider me dumb, but I hadn't checked to see if multiple selected criteria actually worked. I've been working on the rest of the database, trying to get it set up, and didnt notice until just now. It works, technically, but for only for whichever Criteria I selected last. Any idea of where...

Thank you. By passing strCriteria into my subform, it works exactly how I need it to. Thank you, saved me a headache of a time. Out of curiousity though, because I would like to learn more about VBA as its heavily used in my office, can you explain the line strCriteria = Mid(strCriteria, 6) to...

Only the record number two.

When the user selects Derick Dave and Nick, I want all records with field NAME that contain those selections. If they only pick Nick, then display the records with at least Nick. EDIT: New to Access, kind of thrown on my by my boss randomly. So Ive been learning this past week. Im starting to...

Ive been searching for several hours, but I have not found a single solution to what Im looking for. To make a long story short, I have a query that I need to put into a subform in datasheet view, or alternatively a listbox. And then have another listbox, with multiselect enabled, to filter...