limit records displayed

[Jollywg]

I'm using 2 forms one is a customer entry form and the second is an invoice entry form for that particular customer. I'm sending the invoice form the customer id number to keep the link up. The form is set as a continuous form and what i am having the user do is press a button to add a new record. For example the customer needs a piece of equipment and the accessory to that equipment. This would be on two lines (records) in the continuous form. The only problem is that if when i press the button to bring up the invoice form it shows the current customer id number and all of the invoice records for all the customers...any ideas?



Thanks in advance!

[NeoPa]

...
I'm sending the invoice form the customer id number to keep the link up.
...

How are you doing this?

It seems this is the bit that's failing so tell us how you're doing it at the moment.

[Jollywg]

How are you doing this?

It seems this is the bit that's failing so tell us how you're doing it at the moment.

I'm not real sure that this is the problem because it is displaying the information that I have in the appropriate textboxes:

Private Sub btnCreateInvoice_Click()
On Error GoTo Err_btnCreateInvoice_Click
 
DoCmd.SetWarnings False
 
    Dim stDocName As String
    Dim stLinkCriteria As String
    Dim strSQL As String
    Dim strSQLUpdate As String
 
    strSQLUpdate = "UPDATE tblScratchInvoice INNER JOIN tblInvoice ON tblScratchInvoice.InvoiceNum = tblInvoice.InvoiceNum SET tblInvoice.InvoiceNum = [tblScratchInvoice.InvoiceNum], tblInvoice.FreightCompany = [tblScratchInvoice.FreightCompany], tblInvoice.ProNumber = [tblScratchInvoice.ProNumber], tblInvoice.PartNum = [tblScratchInvoice.PartNum], tblInvoice.Description = [tblScratchInvoice.Description], tblInvoice.ItemCost = [tblScratchInvoice.ItemCost], tblInvoice.Qty = [tblScratchInvoice.Qty], tblInvoice.TotalCost = [tblScratchInvoice.TotalCost], tblInvoice.InvoiceTotal = [tblScratchInvoice.InvoiceTotal], tblInvoice.AgentRef = [tblScratchInvoice.AgentRef];"
 
    DoCmd.RunSQL strSQLUpdate
 
Exit_btnCreateInvoice_Click:
    Exit Sub
 
Err_btnCreateInvoice_Click:
    MsgBox Err.Description
    Resume Exit_btnCreateInvoice_Click
 
End Sub

I forgot that since i posted this last i decided to move to a query that runs every time the invoice button is pressed. Oh i also know that right now its not opening up my frmAppend. I took this out for debugging purposes.

[NeoPa]

How are you doing this?

It seems this is the bit that's failing so tell us how you're doing it at the moment.

I thought this was a fairly straightforward question. Please let me know if this is hard to understand, or if you have answered it, but I just can't see it in your post.