Search results

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"...

Thanks y'all!

Because I don't want an empty record on my form

Takes me awhile... but this is how I get it.

I've been using this simple sub to delete records (which I very seldom do, so I was unaware...) and discovered I was deleting the wrong record. I believe the problem is in the Me.FilterOn = false line and when I comment it out the proper record is deleted. If I don't turn off the filter, move...

yup. working well.