Search results

Sorry... I put it on a back burner and moved on. So how can I look at multiple invoices under each customer?

I Did! I Did! Exactly. Does not go from Amount to Description. On the one I posted and Downloaded and tried again. I Did!

I always thought I was lucid! You force me to rewrite and rewrite!;):)

New invoice adds a new date and invoice number then it should go to detail (Description). I did exactly as you said. Tab after amount jumps up to Received. UNLESS there is another record in the detail. It cycles through established records. It will not add a new record (or item line)

Right. That's not happening. Something on my end?

No. I want it to go back to description after amount. Continually adding details. I also want it to start in Description when I add a new invoice. It goes to received. Unless there's a second record. Then it cycles through the records. It will not cycle to a new record.

gladly

tabbing through the invoice form (sub 2) goes line to line. jumping to the invoice detail jumps back to invoice... line to line. Never wants to go to detail unless I mouse down. I've also tried this and can't get it to work (last line): Set dbs = CurrentDb Set rst = dbs.OpenRecordset("Select *...

yes to both. I can add... I just have to mouse it

yes

Oh good idea. thank you so much

The only tab fields on the 2nd subform below (Invoices) are Received, Date Rec'd, and Check #. When I add a new invoice I want to jump to the 3rd subform, Description and Amount. After entering the amount on the first item the tab moves back to Received in the 2nd subform. I want to continue...

I have delete buttons at the end of each item in the invoice (3rd sub form) so I can quickly get rid of a line I don't want. The continuous form adds a blank line and if I hit the delete button on the empty record it gives a 3075 error because it doesn't have an ID yet. Is that a place to put an...

OH OH OH!!! Now I just feel stupid! Me.Parent.Parent.Name returns frmAAAA! I did not realize I needed to check the report's openargs. THANK YOU SO MUCH... ALL

Yes... Me.Name is what I usually use. However, I'm calling from the sub, sub form

Null, also. Am I missing something here?

OpenArgs:=Me.Parent.Parent.Name returns null Function getmainform... How do you use it? OpenArgs:=GetMainForm ? OpenArgs:=obj ? I want to manipulate.... just can't figure how!

yes. Main Form -- frmAAAA Sub Form 1 -- frmsubDetail Sub Form 2 -- frmsubInvoice -- Here is where the report button is. So, you would think Me.Parent.Parent.Form.Name

I use it on the report to make it visible when I close the report. Usually I just use Me.Name but this button is down in the 2nd subform.

I want to pass the name of my form to the report it's calling. The calling button is on the 2nd sub form. So I've tried Me.Parent.Parent.Form.Name Dim frm as Form Set frm as Forms!frmAAAA OpenArgs = Me.Name the following: Dim frm As String frm = "Forms!frmAAAA"...