Auto-fill a Subform using a Data from the mainform

[clairebear]

Hi,
So I am new in Access and what Im trying to do is to allow my subform to auto-fill data from my main form.
MY main form is frmBilling and subform is frmDetails. Fields in my main form includes Billing No which is an Autonumber field. Subform also includes a Billing No field.
What I would like to do is that whenever Access creates a new Billing No, it would fill the subform with the corresponding Billing No.

Hope you could help me.
Thanks in advance.

[June7]

Is BillingNo set as primary key field in Billing table? Set subform container control Master/Child Links properties. This will synchronize records. The BillingNo will automatically populate into the subform records when data is entered into any other subform field.

Might want to make the two BillingNo field names slightly different, such as BillingNoPK and BillingNoFK.

Advise no spaces or special characters/punctuation (underscore is exception) in naming convention.

[clairebear]

Yes, the billingno is set as primary key in the billing table.
However, another problem is that the data in the subform is pre-entered. which means that when BillingNo in the main form is created, i want that it will automatically show in the subform and update the data in the table. Is this possible?

Thanks

[orange]

Suggest you look for youtube videos for Msaccess --form/subform like this one

[June7]

I don't understand. If the data in the subform is pre-entered, when does that happen? If there is not already a value in the subform BillingNo, the main and subform records cannot synchronize. Your image makes no sense.

[clairebear]

I don't understand. If the data in the subform is pre-entered, when does that happen? If there is not already a value in the subform BillingNo, the main and subform records cannot synchronize. Your image makes no sense.

Okay, here's more details about the form Im trying to make. The form is supposed to create a Unique billing number and associate it to the DRDetails. The DR Details data are pulled up by Access thru the Client Name. Thus, DR Details are stored first. Then when the user opens the form and types in the clients name in the mainform, the corresponding data will be shown in the subform and a corresponding number will be generated in the Billing No field in the main form. What I want to happen is the when the corresponding number in the Billing form is generated, I also want it to appear in the subform and when I click the Save number i would want to save it in the table.

For example I typed in Client A. All DRDEtails with Client A's name will appear. Then Access generated billing no 10. I want all Clients A's DRDetails to also have billing no. 10. Do I make sense? Thanks.

[June7]

Conventional approach would be to create the billing record then select the client records to be associated with the billing.

In your situation, use an UPDATE sql action. The real trick is figuring out what event to put the code into.

CurrentDb.Execute "UPDATE tablename SET BillingNo=" & Me.BillingNo & " WHERE ClientID=" & Me.Client & " BillingNo Is Null"

Why is the Amount value showing aligned left like text?