subform - datasheet view, new record at top

  • Thread starter Thread starter JulieD
  • Start date Start date
J

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
 
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


Allen Browne said:
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")

JulieD said:
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
Click to expand...
unless
a
button is pressed in the subform.

Cheers
julie
Access 2000
Click to expand...
Click to expand...
 
Hi John

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

Regards
Julie
 
Back
Top