Can not add data into a form opened by another

[LittleNick]

Greetings,
I have a main form where there are users info, and a button when click it will open a second form named Vehicledata. These forms are link with userid. My problem is when I click to open the Vehicledata form, I can add the first record fine into the Vehicledata form, but then when I try to add a second record (because for example John can have 2 cars, different color and tag...), I received a message saying "The data was added to the database but the data won't display in the form...underlying record source". I did not even see the data saved into my SQl table. And I changed the record source to a view but I still have the same error. Can you give me an idea on how to fix this or an alternative on how to add multiple records?
Appreciate your helps.

 

[SeeThru]

How are the two tables related?

You may have set something where each user record can only have one vehicle record, possibly by linking on the wrong field.


Table UserInfo
UserID (primary key)
Name
Address
etc


Table VehicleInfo
VehicleID (Primary key)
UserID (NOT primary, NOT unique values, same type as Userinfo table)
Make
Model
etc.

You then link the two UserID fields in a one to many relationship.

SeeThru
Synergy Connections Ltd - Uk Telemarketing and Telesales Services and
Synergy Mobile Solutions - UK Mobile phones, land lines and call packages