I want to use the .orderby property. I have a field on the query called reference number.You can pass in a filter and all other properties.
dim frm as Form_SomeForm
set frm = new Form_SomeForm
with Frm
.filter = "salesid = " & me.salesidforquery
.filterOn = true
.OrderBy = SomeField
.backColor = someColor
...... whatever you want to set
end with
Yes my fault, I was just trying to list some properties. My example should be
.OrderBy = "SomFieldName"
.OrderByOn = True
So is it 'reference number' or 'ReferenceNumber' ?
I've tried
.orderby = "ReferenceNumber" doesn't but doesn't work.
So why did that not work?
You can pass in a filter and all other properties.
dim frm as Form_SomeForm
set frm = new Form_SomeForm
with Frm
.filter = "salesid = " & me.salesidforquery
.filterOn = true
.OrderBy = SomeField
.backColor = someColor
...... whatever you want to set
end with
.Where do you get all this stuff from. I can never find stuff like this from a google search
OK looks like with instances you have to 'do' things whilst setting the form up.
So I know I'm going to have a few questions on this.
One at a time...
How do I hide columns.
Conventional way doesn't seem to be working. I'm using a split form at the moment but may ditch that as it's proving troublesome.
The next question may be a biggy so I'll make sure I can't do it in the normal way first.
Search for emulated split form in this forum, might be a better option.?
So the questions that you are now asking have nothing to do with form instances. You are opening a non dialog form and you want to set certain properties. I would probably say to open a new thread, because it is about setting form properties and not dealing with multiple form instances. However, yes you can hide columns in a split form. Not really my thing, I prefer to roll my own forms so I can better control them.