Enter data into multiple tables from one form (1 Viewer)

When you say you get an error, please provide exactly what that error is - error message, wrong result, nothing happens.

Fixes:

1. subform RecordSource can simply be TransactionTbl - SQL statement did not include all fields

2. set subform container Master/Child Links properties to CustID fields

3. bind Combo0 to VehRegNo field

4. make CardType a combobox

5. TransactionID textbox should be at least Locked Yes and TabStop No. Or don't even have this textbox. Users don't need to see this field.

Hi June7

The error message is "you cannot add or change a record because the related record is required in table customertbl' . But I don't want to add or change anything in that table, all I want to do is add the transaction details into the transaction table.

Did you try the fixes? Or examine the db provided by Mike to see what's different from yours?