Datasheet

T

tjh

Hello,

I would like to use a form in datasheet view. How can I limit the number of
records that appear in this view. I would like to limit it to 1 record in
some situations and to a group of records in other situations. Also, is there
a way to remove the extra line (*) when using the datasheet view.
 
N

Nikos Yannacopoulos

Your first question is too general to be answered. What candition imposes
the number limit? Pls be more specific.

The second one is simple: open the subform in design view ans set the form's
Allow Additions property to No. This way, the subform will allow you to edit
existing records but not to add new ones, so the new record line (the one
with the *) will not be there.

HTH,
Nikos
 
Top