Hi All,
Please could you assist
I have a string value of 2010-0006-CN, I want the query to show me all records like this one
When using Like "*2010-0006-CN*" I only get 2010-0006-CN but i know I also have a record 2021-0006
When I link this form to another form I would like to use below but the result is null
The 2010-0006 would be m primary search, I could even have a 2010-0006-A or 2010-0006-1 as a record set
Please could you advise
Please could you assist
I have a string value of 2010-0006-CN, I want the query to show me all records like this one
When using Like "*2010-0006-CN*" I only get 2010-0006-CN but i know I also have a record 2021-0006
When I link this form to another form I would like to use below but the result is null
Like "*[Forms]![SB Detail - Not Loaded]![SB/AD No]*"
The 2010-0006 would be m primary search, I could even have a 2010-0006-A or 2010-0006-1 as a record set
Please could you advise