Is there a way to not show the "entry" record in the subform and still show the records continuosly.

I´ve always wanted to know this but it didn´t seem that important until now. I´m designing for people that are completely new to access and perhaps not all that used to computers in general.

The thing is, the "entry" record makes the subform a bit confusing.

Fuga.

Are you talking about the blank record where you can input new records? With a [>*] prefix?

I think the short answer is "no, but."

The long answer is, you can make your form open with additions turned off and it will not be there. If this form is just to view data, not enter it, that should work for you. Perhaps include a button to make it so they can input data once more.

HTH,
David R

Thanks, David R.

I have the allowaddition set to false.

In the head of the subform I put a command button with:

Forms!myformname.allowadditions=true

And then, for the "close" button:

Forms!myformname.allowadditions=false
close

The thing is it works when I only open the form itself, but not when I use it as a subform (which is what I want to do).

Access tells me the form can´t be found.

What am I missing?

Fuga.

if you are referencing a subform you have to explicit reference the form otherwise the code thinks its the object on the main form.

so rather than:

Forms!myformname.allowadditions=true

try:

Forms!myformname.Form.allowadditions=true


Ian


[This message has been edited by Fornatian (edited 03-17-2002).]

[This message has been edited by Fornatian (edited 03-17-2002).]