Dear All,

I have data entry form developed in Access. This data entry form is bound to
a database table. This data entry form has some textfields and a submit
button.
What I want to do is that when I press submit button. The record from the
text boxes should be inserted into the database. Also I have 1 field which
remain constant. Basically I am adding multiple records against 1 ID field
which is read only text. The text in rest of the text boxes should change as
soon as I press Add new Record Button.
Any help would be greatly appreciated.

cheers,
Sam Solomon