Please help to add new data to a subform?

[markpastoril]

Subform fill out form for posting of bill
This is my billing form which I would like to design to be updated and add data by clicking on a hyperlink, and it would opens a form, that i would fill the info/data to be billed. please help me how to properly add new data to the current account, when it opens.

Thanks in advance.

[June7]

This requires code to pass account number to the popup form. If you want to avoid that, enter billing info into subform instead of a popup.

[markpastoril]

I would like to make/ fill the data in other form, so it will not be easily edited or deleted,I think?

[markpastoril]

can help me with the code sir?

[June7]

So those records I see in your subform are locked against editing?

Okay, code can be like:

DoCmd.OpenForm "Post_Billing_Form", , , , acFormAdd, , Me.CustomerID

The trick will be figuring out what event to put that line in.

Then code behind the popup form.

Private Sub Form_Load()
If Me.NewRecord Then
    Me.CustomerID = Me.OpenArgs
End If
End Sub

I am only guessing about the names for the primary and foreign key fields that link these tables. Adjust as needed.

Advise not to use spaces nor punctuation/special characters (underscore only exception) in naming convention. Better would be AccountNum or AccountNo or AcctNum.

[markpastoril]

Tried it sir/mam, but it did not respond or opens the form.

[orange]

Why not post a copy of the database so readers can see your table(s) and relationships, and the code involved?