Access VBA OpenForm Grouping and Sorting -

i have form used data entry. have go through , add data these records. there way pull form groups records field "a" , sorts field "b"? order forms a1-1, a1-2, etc, making adding data easier.

right using docmd.openform display records values in fields. need modify bit?

thanks help!

[edit]

i load form on button click have

private sub btndataentry_click()      docmd.openform "data sheet", acnormal, , , acformedit, , openargs:="mapnumber" end sub 

then suggested

private sub form_load()      if not isnull(me.openargs)          main.orderby = me.openargs          main.orderbyon = true      end if  end sub 

this not working me. if possible group map numbers , have item numbers ascending. there 10 entries map number 1 , item numbers 1-10.

openform doesn't include option specify sort order. use openargs option pass in sort information, apply during form load.

private sub form_load()     if not isnull(me.openargs)         me.orderby = me.openargs         me.orderbyon = true     end if end sub 

then open yourform sorted field named id in ascending order ...

docmd.openform "yourform", openargs:="id" 

include desc descending order ...

docmd.openform "yourform", openargs:="id desc" 

use version of form_load troubleshoot why form opens without sorting expect.

private sub form_load()     msgbox "me.openargs: " & nz(me.openargs, "null")     if not isnull(me.openargs)         me.orderby = me.openargs         me.orderbyon = true     end if     msgbox "me.orderby : '" & me.orderby & "'"     msgbox "me.orderbyon: " & me.orderbyon end sub