Entering notes in subform - entering new one at the top

V

vangogh228

Registered User.
Local time
Today, 16:21
Joined
Apr 19, 2002
Messages
302
I have searched the forums on several terms, like descending, notes, dates, sort, subform, continuous... but am not finding the answer I am looking for. Any help would be greatly appreciated.

I am trying to enter notes in a continuous subform where the notes are entered with a date field defaulted to today. I would like the previously entered notes to appear in descending order (newest first) but ALSO need to have the entry field for the next note to be at the top. I have a hidden autonumber field, hoping to use that to sort for notes that are entered on the same day.

I have the subform linked directly to my notes table. Should I use a query instead? What would be the advantage of doing that... is there some functionality that would become available that I can't use now?

THANKS for any help!!!

Tom
 
You can't. You can sort the historical entries but the new entry is always at the bottom.

But you can cheat! Create two subforms, one in data entry mode for a single record and a continuous form that's read only. Stack them on top of each other so that it looks like a single subform.
 
Neat trick... I wasn't sure if I could/should really do that. THANKS!
 
OK, I did it... but...

The sorting doesn't put the new ones at the top. I built a query to drive it, using my autonumber sorted DESC, which resulted in an entry in the Order By field, but the notes still show building at the bottom.

Also, if I have Form1, subform1 for my order entry and subform2 to display the notes history, how do I refresh to get my just-entered note (in subform1) to immediately display in subform2?? I don't know what to do here...

THANKS again!
 
vangogh228 said:
The sorting doesn't put the new ones at the top. I built a query to drive it, using my autonumber sorted DESC, which resulted in an entry in the Order By field, but the notes still show building at the bottom.
Click to expand...
Not obvious what is happening here. Can you do a screen grab of your form, or even better, post a stripped out and compacted version of your database.

Also, if I have Form1, subform1 for my order entry and subform2 to display the notes history, how do I refresh to get my just-entered note (in subform1) to immediately display in subform2?? I don't know what to do here...
Click to expand...
Have a look at the Requery comand in VBA.
 
You have created a sorted query for the notes, but you've based the form on the table. If you base the form on the query it will sort as you want it.

You'll need some code to refresh your subform. I'll try and look at this later today.
 
Wow...

sometimes it is amazing what obvious stuff you miss. THANKS!!!

I think... hmmmm... would this be a me.requery on the after update event of the note? I'll try that, but not sure what's going to happen here. I've never requeried on a subform before.
 
Aha!

I entered an after-update event on subform1 that subform2 be requeried, and it works perfectly.

THANKS FOR YOU HELP, NEIL.
 
You must log in or register to reply here.

Similar threads

J
Sorting & Alerting User that Subform has more than 1 record
Replies
3
Views
249
Pat Hartman
P
J
Im an absolute beginner. Please help
Replies
6
Views
298
Pat Hartman
P
T
Solved How to make vba check all records in continuous form not only top one record
Replies
14
Views
601
TMK
T
W
Solved From with One-To-Many Relationship table
Replies
19
Views
688
wmix
W
D
Solved Subform adding blank record
Replies
16
Views
534
dullster
D

Users who are viewing this thread

Total: 1 (members: 0, guests: 1)
Back
Top Bottom