Refreshing sort order after record added - subform

  • Thread starter Thread starter requeth
  • Start date Start date
R

requeth

I have a subform which I will call SubformA, I then have two items
Comment_Date and Comment. I just have it so a new line is inserted
after previous comments that you can type into, and then it adds the
new comment record. What is annoying me is that I want the newest
comments first, and it sorts properly on load, but when I add a new
record, it doesent add it to the top of the comments. Is there a way to
either redo the sort order - or to move the blank boxes to the top of
the list so that's where the comment will populate?
Just to do the sort I tried After Update=[Comment_Date].[Refresh] but
my code is wrong I guess.


Typing this up I had about 5 questions, now all but the one above was
answered, gotta love thought processes. The one above is just too
technical for me at the moment I think, I've forgotten all my VB!

RT Starid
 
Refresh *only* refreshes existing records in the recordset. You would need
to use .Requery to pick up new records and re-sort the recordset.

I have a subform which I will call SubformA, I then have two items
Comment_Date and Comment. I just have it so a new line is inserted
after previous comments that you can type into, and then it adds the
new comment record. What is annoying me is that I want the newest
comments first, and it sorts properly on load, but when I add a new
record, it doesent add it to the top of the comments. Is there a way to
either redo the sort order - or to move the blank boxes to the top of
the list so that's where the comment will populate?
Just to do the sort I tried After Update=[Comment_Date].[Refresh] but
my code is wrong I guess.

Typing this up I had about 5 questions, now all but the one above was
answered, gotta love thought processes. The one above is just too
technical for me at the moment I think, I've forgotten all my VB!

RT Starid
Click to expand...
 
Back
Top