By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,952 Members | 1,686 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,952 IT Pros & Developers. It's quick & easy.

limit records displayed

100+
P: 158
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
Share this Question
Share on Google+
3 Replies


NeoPa
Expert Mod 15k+
P: 31,342
...
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

100+
P: 158
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
Expert Mod 15k+
P: 31,342
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.