Docmd.runsql

[PraizesLiberato]

I tried to use the docmd.runsql command. its gives me an error message and doesnt execute properly. The pic of the message is attached herewith.

 

[the_net_2.0]

it's a key violation error, just like it says. You might be appending records that would create a duplicate number in a PK field, or something similar. check your PK index setting and the records you're appending.

 

[PraizesLiberato]

I checked the table duplicates are allowed.

This query executes when a dropdown is changed. I did try this query seperately in the query biuilder it works perfectly. but the same doesnt run when the dropdown changes.

 

[the_net_2.0]

how many total records does the append query try to execute? 4? is the form source the actual table that's receiving the records?