Please be more specific. See Rule #2.

send screen shots of your tables in design view

You can either use default values or VBA coding to update those values. Since I don't know how much VBA you know, I'd recommend default values. See Default Value and Value From a Form.

Hi there, herewith the code I used, but its not working..... I need the job card directly linked to the Customer Order and to push data from Customer Order to Job Card such as Aircraft type and Enginer serial number as well as the Workscope.... Im not very clued up. But am trying my best to get this right. Private Sub cmdCreateJobCard_Click()
    On Error GoTo Err_Handler
    
    ' Debugging statements to trace button click event
    Debug.Print "Button Clicked"
    
    Dim stDocName As String
    Dim stLinkCriteria As String
    
    stDocName = "frmJobCard"
    stLinkCriteria = "[OrderID] = " & Me![OrderID]
    
    ' Debugging statements to verify values
    Debug.Print "Document Name: " & stDocName
    Debug.Print "Link Criteria: " & stLinkCriteria
    
    ' Check if OrderID is valid before proceeding
    If IsNull(Me![OrderID]) Then
        MsgBox "OrderID is null. Please select a valid order.", vbExclamation
        GoTo Exit_Sub
    End If
    
    ' Open the Job Card form with the selected OrderID
    DoCmd.OpenForm stDocName, , , stLinkCriteria
    
    ' Debugging statement to confirm form opened
    Debug.Print "Job Card form opened"
    
Exit_Sub:
    Exit Sub

Err_Handler:
    MsgBox "An error occurred: " & Err.Description, vbExclamation
    Debug.Print "Error: " & Err.Description
    Resume Exit_Sub
End Sub

Hello, thank you for the response, however the two videos don't really cover what I need. I need to open a job card from the customer order with some information that will populate the job card that is already in a field in the customer order.? If you have a tech help video explaining that, if you can send me the link then I can try and solve it. Thank you so much.

Your code would only work if the OrderID field were in the main form (frmJobCard), but it's not.  It's in the subform (sbfOrder_JobCard), as your last screenshot shows.  That's why your code doesn't work.  Find a way to put OrderID on the main form, even as a hidden control, if necessary.

This is a question I get asked a lot. "How to push a value to another form." I actually have a video on this subject on my list. I'll bump it up for you.

Also, your tables show there is a space in the field name "Order ID"; but in your VBA code, you use "OrderID".  What you use in VBA has to match what is on the form, which, in turn, has to match what is in the underlying tables.

Good catch, Kevin.

how about the DLOOKUP to copy value from one table to new table by matching the ID?  not sure just a thought....

See: Push a Value

I SEE said the blind man.... LOL

...to his deaf son.

Hi there, thanks so much for the video. Very helpful, at least got the Job Card created from the Order and populated some of the data from Order to Job Card, however, after completing the exercise, there is just no way that the new Job Card that was created from the Orders form will save that new record.  You can populate or input data, you can add a save button, I've tried and tried but that "new"record will not save... Don't quite know what I'm doing wrong?

The method given here to place data, or trigger an action in different forms, certainly works, but there's an alternate method that I use, that I believe makes your code simpler and less prone for errors as the number of forms sharing data increases.   Here's a link to an Access project that demonstrates this alternate method of sharing data or triggering actions in one or more other forms.

https://github.com/NfaToys/Global-Messaging-Events-Class/blob/main/Event%20tests.accdb

Click on the [***] three dots to the Right of the name of the Project to download.    "Event tests.accdb" is a small Access VBA Project that demonstrates the use of a global Class module that provides custom events that allows forms to trigger actions within themselves or with each other.   This Class module concept gives the developer the power of designing custom form events.  Forms can easily trigger actions within themselves, or trigger events in other forms to perform their own actions.   A practical use of this would be a database that has several forms open that share the same data.  When data is changed in one form, ideally you'd want all other forms to update their displays to reflect the change.   This can be done using function calls for each form, but with this approach the code becomes clumsy and hard to maintain when the number of forms sharing data is numerous.   The better way is to use custom Events.  As each form opens it hooks into the Event chain of the global Event class.  Then each form sinks and handles the pertinent events for that form.  And when the form closes it unhooks from the event chain.