SubForm Options

[raffi]

hi i have a form and a in it a subform and it requery's the subform whenever i add info which it is great an all, but the new information are being added at the very bottom of the subform :S ... is there a way of adding from the top of the subform ?

thank you

[Bob Fitz]

I think this could be done by having a date/time field in the table that is used for the sub form that is populated with Now() each time a record is created, then create a query from this table and set the order by of this date/time to Desc

[June7]

That will bring the newly saved record to top but regardless of sort order, the NEW RECORD row will still be at the bottom of the form.

[Bob Fitz]

That will bring the newly saved record to top but regardless of sort order, the NEW RECORD row will still be at the bottom of the form.

Indeed, that is of course correct June. I hadn't realized that was a problem for the OP but you're probably right about that as well. In which case perhaps the OP could create a separate form for the actual data entry? Your thoughts?

[raffi]

ok i had a link between child field and master field date/time, i removed it and it worked, thx hmm ... ill probably make another date/time and set it to date() just for the sake of not overpopulating the subform beneath the data entry table but hey thx guys

[Bob Fitz]

..... but hey thx guys

I'm not certain about this but actually I think June is a "Gal" rather than a "Guy"

[June7]

I won't nitpick over the group reference 'Guys'. Even us 'Gals' do it, it is so ingrained in our conversation.

I had an uncle named June.

[raffi]

im sorry didn't notice there! haha! nice name tho! =)