How do I make make my form start from new entry

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

Set the form's Data Entry property to Yes.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"PS" wrote in message
...
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

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

"Allen Browne" wrote:

Set the form's Data Entry property to Yes.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"PS" wrote in message
...
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

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

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"PS" wrote in message
...
In doing this now I cannot add data to the form or use my combo box any
other
suggestions?

"Allen Browne" wrote:

Set the form's Data Entry property to Yes.


"PS" wrote in message
...
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

I have them both set to yes.

"Allen Browne" wrote:

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

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"PS" wrote in message
...
In doing this now I cannot add data to the form or use my combo box any
other
suggestions?

"Allen Browne" wrote:

Set the form's Data Entry property to Yes.


"PS" wrote in message
...
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

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.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"PS" wrote in message
...
I have them both set to yes.

"Allen Browne" wrote:

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


"PS" wrote in message
...
In doing this now I cannot add data to the form or use my combo box any
other
suggestions?

"Allen Browne" wrote:

Set the form's Data Entry property to Yes.


"PS" wrote in message
...
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

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" wrote:

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.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"PS" wrote in message
...
I have them both set to yes.

"Allen Browne" wrote:

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


"PS" wrote in message
...
In doing this now I cannot add data to the form or use my combo box any
other
suggestions?

"Allen Browne" wrote:

Set the form's Data Entry property to Yes.


"PS" wrote in message
...
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

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.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"PS" wrote in message
...
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?

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" wrote:

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.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"PS" wrote in message
...
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?

Yep.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"PS" wrote in message
...
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?