Still not getting to grips with adding a record to another form.

[Bopsgtir]

Hi all i know this is probably a very basic question, ive got a form that i enter a new starter into the business, this is recorded in my table Techs, on the form there is a tick box asking if the tech needs a fuel card, if he does i want a record to be added to the table FuelCard, but ive no idea how to do it, im new to access and im struggling to not see things in the same table.

 

[Peter D]

You can use an SQL statement to insert a record in a table. Here is a VBA example for use in an event procedure, function or subroutine:

currentdb().execute "Insert into MyTable (MyNumericField1, MyTextField2) Values (23, 'ABC');", dbseechanges + dbfailonerror