If there is a relationship between the underlying tables, you may be able to
build a subform to add the data to subsequent tables, if not, you can
probably built a recordset and use AddNew. Here's some aircode:

Sub cmdAdd_Click()
On Error GoTo Error_Handler

Dim db As DAO.Database
Dim rst As DAO.Recordset

Set db = CurrentDb
Set rst = db.OpenRecordset("tblNameHere", , dbAppendOnly)

With rst
   .AddNew
   !ActorName= Me.txtActorName
   !OtherField = Me.txtOtherData
   .Update
   .Close
End With

Exit_Here:
rst.Close
Set rst = Nothing
Set db = Nothing

Error_Handler:
   MsgBox Err.Number & ": " & Err.Description
   Resume Exit_Here
End Sub

Sure. These things are normally accomplished using subforms.

You would first create a form whose Data Source is the film table. Then
create another form whose Data Source is the actor table. Finally, open up
the Film form in design view  and add the Actor form into it as a sub form.

To simplify, I  want to add a film number in a record, and without exit the
form, switch in modify mode to modify other fields of this record. Is it
possible ?