Access App

[kaito]

Hi guys,

I'm super new user in Access)

Could you please help me, it would look that way



I have 3 forms, "Request_Form" >>> (Req_Numb) (Req_Date) (Positions) (Qty)


"Recruitment Form" >>> (Req_Numb) (Req_Date) (Positions)

I need to after fill out fields and close "Request form" (req_Numb) (req_Date) (positions) must be automatically copy to "Recruitment form"

Which VBA code? How?

[NoellaG]

Copying data from one table to another is generally not a good idea in a database. Maybe you could post your table setup and tell us what you want to achieve copying those data?

[ranman256]

No vba needed. Use an append query to copy the data.

[orange]

kaito,

Tables store data. Forms are like windows to view the data.
As Noella asked --what do you want to do with the copied data?
If you could describe what you have and what you need in simple English, then readers could offer more focused suggestions.
We need to know What is required, before addressing options for HOW.