data entry in reverse order?

  • Thread starter Thread starter kim
  • Start date Start date
K

kim

hi!

i have a data entry form attached to the table, which is a
simple list of records. by default, as you add a new
record, its content is displayed at the bottom of the
form. since i have to refresh the form as the record is
updated, the cursor or the pointer moves to the first
record after the form is refreshed. as the users add more
records, this becomes an issue, since they have to scroll
down for the new line at the bottom.

my question is: is there a way to show the new data entry
line in the first line of the list form? or would you
approch to this issue differently?
 
Hi Kim,

I've never actually done this but I think the easiest way to do this would
be to use two identical subforms, one that is in DataEntry mode and is on
top. The second would be below the first and would have DataEntry and
AllowAdditions set to false. Then make sure that the second subform is
always requeried after an update in the first subform.
 
hi, sandra! yes, it worked. but how can i make the second
subform being required? in the properties of second
subform i assume???

-----Original Message-----
Hi Kim,

I've never actually done this but I think the easiest way to do this would
be to use two identical subforms, one that is in DataEntry mode and is on
top. The second would be below the first and would have DataEntry and
AllowAdditions set to false. Then make sure that the second subform is
always requeried after an update in the first subform.

--
Sandra Daigle [Microsoft Access MVP]
Please post all replies to the newsgroup.

hi!

i have a data entry form attached to the table, which is a
simple list of records. by default, as you add a new
record, its content is displayed at the bottom of the
form. since i have to refresh the form as the record is
updated, the cursor or the pointer moves to the first
record after the form is refreshed. as the users add more
records, this becomes an issue, since they have to scroll
down for the new line at the bottom.

my question is: is there a way to show the new data entry
line in the first line of the list form? or would you
approch to this issue differently?
Click to expand...


.
Click to expand...
 
Use the AfterUpdate event in the first Subform to requery the second
subform. The syntax requires that you reference the second subform control
through parent form so to do that from the first subform:

me.parent.sfrmSecond.requery

Where 'sfrmSecond' is the name of the second subform control. Click once on
the subform then look under the Other tab for the Name property. What you
find there is the name of the subform control.


--
Sandra Daigle
[Microsoft Access MVP]
For the benefit of others please post all replies to this newsgroup.

hi, sandra! yes, it worked. but how can i make the second
subform being required? in the properties of second
subform i assume???

-----Original Message-----
Hi Kim,

I've never actually done this but I think the easiest way to do this
would be to use two identical subforms, one that is in DataEntry mode
and is on top. The second would be below the first and would have
DataEntry and AllowAdditions set to false. Then make sure that the
second subform is always requeried after an update in the first subform.

--
Sandra Daigle [Microsoft Access MVP]
Please post all replies to the newsgroup.

hi!

i have a data entry form attached to the table, which is a
simple list of records. by default, as you add a new
record, its content is displayed at the bottom of the
form. since i have to refresh the form as the record is
updated, the cursor or the pointer moves to the first
record after the form is refreshed. as the users add more
records, this becomes an issue, since they have to scroll
down for the new line at the bottom.

my question is: is there a way to show the new data entry
line in the first line of the list form? or would you
approch to this issue differently?
Click to expand...


.
Click to expand...
Click to expand...
 
Back
Top