help with an access form plz

[thecow95]

I am trying to customize a program my employer bought a few years ago that runs in Access 97. I attached a picture to try to clarify what I am trying to do.

I have a form with an Invoice Number(red box in picture), and a repeating sub form for Invoice Line Items(blue box). When something is entered into the Invoice Number box, I want to query our company's database and throw all of the line items in with code. Can anyone help me do this??

I am getting the first one(greenbox in pic) filled with the code below, but I don't know how to move to the second row. A blank entry is created as soon as I put text in the first one, but how do I put text in or even reference the new blank one?

Me![zInvoiceLineitems].Form![Description] = "test1"

Thanks for any help.

[RobDog888]

Your subform "Invoice Line Items" should have a recordsource set
for it and "Source Object" to the parent form "Invoice Number".

Also, the relationship should be set using the "Link Child Fields"
and "Link Master Fields". This will pull in data for a particular
invoice number determined by your subform recordset and filter
based upon the link relationship.

Check it out in design mode, but dont "view in new window" for
the subform, that will give you viewing of subform issues.

HTH