subform - datasheet view, new record at top

[JulieD]

Hi All

Is there any way to display the "new record" (ie the blank one people type
into) at the TOP rather than the BOTTOM of the datasheet view type subform?
or can this be done using a continuous form type subform?

If this isn't possible, can one supress the display of past records unless a
button is pressed in the subform.

Cheers
julie
Access 2000

 

[JulieD]

Hi Allen

Thanks for the reply - it works perfectly ....

on another point, i didn't realise that we had any MVPs in Perth - let alone
Access ones! Do you do consulting / db design work as i'm often asked for
recommendations in this area?

Regards
Julie

No. You cannot place the new record above the existing ones in a continuous
form or datasheet.

To suppress the display of existing records, toggle the form's DataEntry
property. From the main form, that would be:
With Me.[NameOfYourSubformControlHere].Form
.DataEntry = Not .DataEntry
End With

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to the newsgroup. (Email address has spurious "_SpamTrap")

Is there any way to display the "new record" (ie the blank one people type
into) at the TOP rather than the BOTTOM of the datasheet view type subform?
or can this be done using a continuous form type subform?

If this isn't possible, can one supress the display of past records

unless

a
button is pressed in the subform.

Cheers
julie
Access 2000

 

[JulieD]

Hi John

Thanks for this - i'll give it a go and see which way works best.

Regards
Julie