Why two rows in the form and only one in the recordset?

[LAS]

I have a form with "continuous" = true. The form is bound, but when you
first open it, no records will be retrieved because of the value of the
parameters. When I first open it, recordcount = 0 and I see all of the
controls. The bound controls are empty except for one which has a default
value.

I enter the data for the parameters and execute me.requery and get the
expected row returned. RecordCount = 1. The controls are populated with
the row's values.

BUT!!! There are two rows visible now in the form! One is empty and one
has the data from the recent me.requery.

How can I get rid of the extraneous empty row in my form?

TIA
LAS

 

[John W. Vinson]

How can I get rid of the extraneous empty row in my form?

By setting AllowAdditions to No - it's the new, empty row.

Of course you'll see nothing at all when you first open the form.
--

John W. Vinson [MVP]
Microsoft's replacements for these newsgroups:
http://social.msdn.microsoft.com/Forums/en-US/accessdev/
http://social.answers.microsoft.com/Forums/en-US/addbuz/
and see also http://www.utteraccess.com