468,456 Members | 1,780 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,456 developers. It's quick & easy.

limit records displayed

158 100+
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!
Sep 5 '08 #1
3 1643
NeoPa
32,091 Expert Mod 16PB
...
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.
Sep 6 '08 #2
Jollywg
158 100+
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:
Expand|Select|Wrap|Line Numbers
  1. Private Sub btnCreateInvoice_Click()
  2. On Error GoTo Err_btnCreateInvoice_Click
  3.  
  4. DoCmd.SetWarnings False
  5.  
  6.     Dim stDocName As String
  7.     Dim stLinkCriteria As String
  8.     Dim strSQL As String
  9.     Dim strSQLUpdate As String
  10.  
  11.     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];"
  12.  
  13.     DoCmd.RunSQL strSQLUpdate
  14.  
  15. Exit_btnCreateInvoice_Click:
  16.     Exit Sub
  17.  
  18. Err_btnCreateInvoice_Click:
  19.     MsgBox Err.Description
  20.     Resume Exit_btnCreateInvoice_Click
  21.  
  22. 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.
Sep 8 '08 #3
NeoPa
32,091 Expert Mod 16PB
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.
Sep 9 '08 #4

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

6 posts views Thread by middletree | last post: by
6 posts views Thread by Hannu | last post: by
1 post views Thread by subhajit12345 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.