Insert into function

[wajidpharmacist007]

I have two tables PO Detail table having [PO number] and [supplier] fields and PO payment table having [ID] field to autonumber and [PO number] and [invoice number] fields. On the form of PO detail table i have made after update event of DoCmd.RunSQL " Insert into [PO payment]([PO number]]) values [PO number])" on running it warns me to append record but then it gives error please guide.

 

[pbaldy]

This for the warning:

SQL Warnings

www.baldyweb.com

If you mean an error that means the append fails, hard to say without seeing the code and finished SQL. This should help with hte latter:

Debugging

 

[wajidpharmacist007]

This for the warning:

SQL Warnings

www.baldyweb.com

If you mean an error that means the append fails, hard to say without seeing the code and finished SQL. This should help with hte latter:

Debugging

 

[wajidpharmacist007]

Thanks alot it worked

 

[pbaldy]

Thanks alot it worked

Happy to help.