Help with Data Entry Form Please!!

P

PS

I created a form using a query and also I have added a combo box that will
populate the address fields for me. I noticed that at the bottom of the form
it is couting the number of Addresses in the query instead of starting from a
new record. In other words the count at the bottom when opening a new record
says 1 of 79. 79 being the number of address facilities I have in my query. I
would like this data entry form to start from 1 of 1. I have tried changing
the data entry to yes and it will not let me select any thing from my combo
box once this is done. Can someone please help?


PS
 
M

mscertified

The 1 of 79 refers to the number of records that have been read into your
recordset (from your query). This is the default Access behaviour.
The form probably allows you to add, edit and delete records.
To change this default behavious look in Access help at the ALLOWEDITS,
ALLOWDELETIONS and ALLOWADDITIONS properties of the form.
It sounds like you only want to allow additions and not edits or deletions.

Dorian
 
P

PS

Thanks.
Please help with something else? I am trying to set-up my data entry form so
that as soon as someone enter in information. I would like the autonumber to
be set up as such 'CTI-001, CTI-002, and so on and so forth. Can you help me
with this please?

Thanks again
PS
 
Top