Recent content by tonesbones

YESS, thank you so much!! This is going to be very helpful. I tried to take the VB codes apart to understand how it works and if i make adjustments to the code where it replaces the "comma" with a "new line" Me.Text2 = Replace(Me.Text2,",", "')) OR (((TBL_MemberDtl.MemNum)='")to Me.Text2 =...

Hmm, what if I want to add like a giant textbox with multiple rows i.e. Text1: 1 2 3 4 and I want that to be updated to the criteria... is it possible? I know it's just easier to have multitextboxes and then link it together with "or" statement. But I want to make it as flexible as possible.

Thank you so much!! That was such a quick reply. I added a small change to handle empty textbox. IIF(isnull(Forms![Form1]![YourTextboxName]),[NameofField],Forms![Form1]![YourTextboxName])

Dear Access Gods, I'm working on a way to change the criteria of a query using input from a textbox on a form. i.e. An ID number is typed into the textbox and I press a button and the text is automatically updated to the criteria in the query. Even more details: Table: ID SCORE 1 100 2...