Hello,
i feel like i'v gotten close, but just not quiet there yet, would be much appreciated if any suggestions, or help, could be provided, and thank you in advance.
i have a customer table with customer field in it,
i have a query exactly based on the customer table,
i have a form named form1
i got 2 textbox's in Form1, named TxtCustomer1 and TxtCustomer2
now in the query, within the criteria of the customer field, i have the following code indicated below
Code:
Like "*" & [forms]![Form1]![TxtCustomer1].[Text] & "*" And Like "*" & [forms]![Form1]![txtCustomer2].[Text] & "*"
so u see where im going with this, i have placed the query in "form1" as a subform, named Sub1
and the 2 textboxes "TxtCustomer1 and TxtCustomer2" have an "on change" event, which requery's the Sub1
ok so now, the 2 textboxes are operational, and are able to filter the "Sub1" subform in "form1"
but here's the problem, im not being able to filter this 1 column by using 2 textBoxes together, its filtering but separately.
or in other words, after filtering "Sub1" using TxtCustomer1 , when i switch to TxtCustomer2 and start typing, its restarting the sort in Sub1, and starting over, and vice versa.
alright, now i'v actually been able to sort one column with 2 textboxes ,BUT, had to make 2 changes, which are indicated below.
change 1) using "After Update" event, instead of "on change" event
change 2) using the same exact code which i'v posted above, but without the [Text] Control property, which looks like what is indicated below
Code:
Like "*" & [forms]![Form1]![TxtCustomer1] & "*" And Like "*" & [forms]![Form1]![TxtCustomer2] & "*"
again any help would be much appriciated, thank you in advance