How do I make make my form start from new entry

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

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
 
In doing this now I cannot add data to the form or use my combo box any other
suggestions?
 
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.
 
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?
 
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.
 
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?
 
Back
Top