Frank -

Yes. The normal way to add new records is to use the form. You can use the
navigation buttons at the bottom (go the * record) and start entering data.
It will be saved automatically. If you don't need to see the existing
records, you can set the form property Data Entry to Yes, and it will come up
with a blank new record to be filled out (same form, different uses).

--
Daryl S


"Frank" wrote:

On Feb 10, 12:05 pm, Daryl S wrote:
Frank -

You want to add the new Training record that is on the form - the one with
the new training course - you don't want to insert records for all the other
training courses (they already are in the table).

--
Daryl S



"Frank" wrote:
Daryl,

TAINING table does not have primary key and other unique keys. It can
have multipe records for employee_id. I do know why the second
criterial should be EQUAL TO instead of .

Thanks

Frank
.- Hide quoted text -

- Show quoted text -

Yes, It's correct. When I used "" in criterial, not record can add
to the table becouase there is no such record in the table . When I
used "=", all data for the employee were added into the table. It
seems the append query won't work at all. is there any other way to
add (insert) record on the form into the source table.


Thanks
Frank


.