Open with Link Criteria and Columns in Datasheet

[Sash]

I have two questions. First, how do you order columns in a datasheet view?
I tried to order them in the query and on the form, but neither seem to
change the column order.

Next, I'm trying to open a form "frm_CSearch" where the data in the field
"Search" is LIKE whatever is keyed in on the form "MainSearchText". Below is
what I thought would work:

Dim stDocName As String
Dim stLinkCriteria As String
stDocName = "frm_CSearch"

stLinkCriteria = "[Search] like *" & Me!MainSearchText & "*"
DoCmd.OpenForm stDocName, , , stLinkCriteria

My error is syntax error (missing operator) in query expression '[Search]
like *mesh*'

 

[Marshall Barton]

I have two questions. First, how do you order columns in a datasheet view?
I tried to order them in the query and on the form, but neither seem to
change the column order.

Next, I'm trying to open a form "frm_CSearch" where the data in the field
"Search" is LIKE whatever is keyed in on the form "MainSearchText". Below is
what I thought would work:

Dim stDocName As String
Dim stLinkCriteria As String
stDocName = "frm_CSearch"

stLinkCriteria = "[Search] like *" & Me!MainSearchText & "*"
DoCmd.OpenForm stDocName, , , stLinkCriteria

My error is syntax error (missing operator) in query expression '[Search]
like *mesh*'

The pattern operand needs to be in quotes:

stLinkCriteria = "[Search] like ""*" & Me!MainSearchText &
"*"""

so the where condition ends up looking like:

[Search] Like "*mesh*"