Add new record to a table from a form named:frm_Shipping_System,

L

ldiaz

I have a table named:Shipment System
and a field [Bill_Number] as Number because it has a relationships conected
to another table.

I want to add the value from this Combobox [Invoice_No] from a form
named:frm_Shipping_System, this value needs to be added in a new record in
the table:Shipment System when the user press key F4

I just have the criteria, but the code to add the new value is missing,
could you help on this?
========================================
Private Sub WO_KeyDown(KeyCode As Integer, Shift As Integer)
If KeyCode = vbKeyF4 Then


DoCmd.GoToRecord , , acNewRec

End If
End Sub
=====================================

Thanks
LD
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top