How do I make make my form start from new entry

[Guest]

I have created a form for data entry and have a combo box for the address
that I pulled from a query. In the record navigation it is counting the
number of records in the query for my address instead of starting from 1 of 1
it says 1 of 79 (The number of records in my query for my address). Please
tell me how I can make the form stop counting the number in my query and
count only the data I am entering

Thanks in advance

 

[Allen Browne]

Set the form's Data Entry property to Yes.

 

[Guest]

In doing this now I cannot add data to the form or use my combo box any other
suggestions?

 

[Allen Browne]

Sounds like you have the form's AllowEdits or AllowAdditions property set to
No.

 

[Guest]

I have them both set to yes.

Sounds like you have the form's AllowEdits or AllowAdditions property set to
No.

 

[Allen Browne]

Merely setting the form's DataEntry property to Yes will not cause the form
to become read only. You must have made another change as well.

 

[Guest]

No other changes. I just don't understand why it is counting the number of
records in my query instead of the number of records I am actually inputting
into the database?

 

[Allen Browne]

Data Entry mode will not count the number of existing records.

Perhaps you could see now it works if you open the Northwind sample
database, and set the Data Entry property of the Customers form to Yes.

 

[Guest]

Thanks, I did notice however if I wrote the code to say before update and
change the properties to data entry mode then I can add records and also use
my combo box. When I had the combo box coded to after update it would not let
me select anything from the combo box. Could that be the reason?

 

[Allen Browne]

Yep.