Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Reversing sub form order 1
- Thread starter Eurof
- Start date
amourdevin
Technical User
The same question I am hoping to find an answer for.
amourdevin
Technical User
If not adding new records on top of the subform, perhaps a popup type window instead for adding the new record?
TheAceMan1
Programmer
How are ya Eurof . . . . .
Yhe answer is No. New record line at the bottom is standard for access and hard coded. Sorry!
See Ya! . . . . . .
Yhe answer is No. New record line at the bottom is standard for access and hard coded. Sorry!
-
1
- #5
I agree with TheAceMan1
However, with forms, what you can do is create an unbound form and insert two subforms into this form. Both the subforms would be based on the same data source but the first subform should be set as data entry only. This subform would provide you the place to edit a new record.
The second subform could be your current form, displaying all the records. You can disable creating new records in the form to force the users to use only the top subform.
You will need to play with how to display the subforms so that the effect would be as if there was only one form, with the new record line at the top.
You would also need to respond to the afterupdate event in the data entry subform, to reload the records in the other subform, and to reset the entry subform to show a blank record again.
HTH
However, with forms, what you can do is create an unbound form and insert two subforms into this form. Both the subforms would be based on the same data source but the first subform should be set as data entry only. This subform would provide you the place to edit a new record.
The second subform could be your current form, displaying all the records. You can disable creating new records in the form to force the users to use only the top subform.
You will need to play with how to display the subforms so that the effect would be as if there was only one form, with the new record line at the top.
You would also need to respond to the afterupdate event in the data entry subform, to reload the records in the other subform, and to reset the entry subform to show a blank record again.
HTH
Very cool solution lndsy ![[sunshine]](/data/assets/smilies/sunshine.gif "[sunshine] [sunshine]")
As a supplement, in the header or title area of the contineous subform, I place two small command buttons adjacent to the important fields in the subform. I use the small up and down arrows icons. The user clicks on the appropriate arrow which sorts the subform. (Yes, I know, I can right-click on a field and sort the same way -- just trying to make it user friendly)
As a supplement, in the header or title area of the contineous subform, I place two small command buttons adjacent to the important fields in the subform. I use the small up and down arrows icons. The user clicks on the appropriate arrow which sorts the subform. (Yes, I know, I can right-click on a field and sort the same way -- just trying to make it user friendly)
- Status
Similar threads
- Locked
- Question
