Datasheet

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
 
Thank You for your response.

As you can see I am not very experienced in using forms. I would like the
form, in datasheet view, to limit the number of records shown from the table.
This would be similar to setting certain criteria in a query and pulling up a
requested set of records. I am not familiar with how to do this in a form.
The user will also need to be able to update the original data in the table,
so I was thinking that setting the form to reference a query would not work.
What am I doing wrong and what would be the best solution. Thank You,
 
Nevertheless... the general idea is to use text boxes or combos, lists etc
on the form to type in / select your criteria. These should be unbound (i.e.
not bound to the table). You use them as criteria in a query in the
following manner:

Forms![FormName]![ControlName]

If you want the data displayed in datasheet view, then you need to do that
in a subform on your main form, so the main form can host the criteria
controls.

Finally, you will be able to add/edit records through the subform only if
the query itself allows you to do so, which has to do with the table(s)
involved. If it's a single table or sveral with one-to-one relationships
only then you will be able to do so, If, on the contrary, there are two
tables with a one-to-many relationship, you won't - the message you wil get
is "recordset is not updatable".

HTH,
Nikos

If you have yor form in datasheet view, though,
 
Back
Top