Button to sort/ and button to open another form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

1. I am using a continous form called [SEARCH] that looks like a table.
At the top of the column I want a button that will sort the form by that
column field.
When I create a button, I don't know what the script should be.

I know I could just use the AtoZ button on the text of the column, but I'm
trying to build towards a different effect.

2. Then, I want to have a button to correspond to the horizontal row so
that when I find my item code in the list, I click on that button which will
open another form [Inventory] with the same item code as the row I've
selected. Both Tables use the field [item]. These are the fields that
should be equal.

Please advise.
 
1. I am using a continous form called [SEARCH] that looks like a table.
At the top of the column I want a button that will sort the form by that
column field.
When I create a button, I don't know what the script should be.
Click to expand...

Something like:

Private Sub cmdSortField3_Click()
Me.OrderBy = "[Field3]"
Me.OrderByOn = True
End Sub
I know I could just use the AtoZ button on the text of the column, but I'm
trying to build towards a different effect.

2. Then, I want to have a button to correspond to the horizontal row so
that when I find my item code in the list, I click on that button which will
open another form [Inventory] with the same item code as the row I've
selected. Both Tables use the field [item]. These are the fields that
should be equal.
Click to expand...

There's a command button wizard which will give you an OpenForm
action.

John W. Vinson[MVP]
 
Thanks. This answered my question completely. I was also wondering...Is
there a way to use a text box to jump to an entry in my product list? The
person starts typing croissant in the box and rows starting with croissant
are either filtered out or displayed by scrolling to that section. We have
something like that now in another program where we start typing and matching
entries are displayed.



John Vinson said:
1. I am using a continous form called [SEARCH] that looks like a table.
At the top of the column I want a button that will sort the form by that
column field.
When I create a button, I don't know what the script should be.
Click to expand...

Something like:

Private Sub cmdSortField3_Click()
Me.OrderBy = "[Field3]"
Me.OrderByOn = True
End Sub
I know I could just use the AtoZ button on the text of the column, but I'm
trying to build towards a different effect.

2. Then, I want to have a button to correspond to the horizontal row so
that when I find my item code in the list, I click on that button which will
open another form [Inventory] with the same item code as the row I've
selected. Both Tables use the field [item]. These are the fields that
should be equal.
Click to expand...

There's a command button wizard which will give you an OpenForm
action.

John W. Vinson[MVP]
Click to expand...
 
Is there a way to use a text box to jump to an entry in my product list?
Click to expand...

A textbox can be programmed to do so, but if you use a Combo Box it
does so all by itself by default.

John W. Vinson[MVP]
 
Back
Top