Take a look at INSERT - SQL. It's a little neater than APPEND BLANK and REPLACE when you are trying to deal with one at a time record appending as you are here. You can specify which fields to populate in the new records and what values to populate those fields with.

>I have a form with 4 checkboxes. Each check box represents the number of records that needs to be added to a table with the same patient id. For example:
>
>patient id 333-3332-33331
>
>The user receive a registration form and an annual form. So therefore they check those two boxes.
>
>Now when the user wants to add the records and presses submit forms button, I want it to appen to the table two different records.
> Field struc: id,c(12), typeofform, c(20)....
>
>So once they submit the forms, the table will contain two records but the only difference will be the typeofform field containing...
>REGISTRATION in one record
>ANNUAL in the other record
>
>Any ideas?
>
>TIA
>
>Jeff T.