Search results

  1. C

    Solved Variable not defined

    I cannot believe I was so STUPID! I am not a newby! I actually thought I had copied it down because I wanted to check everything before I asked. I thank you so much for your trouble! Going somewhere to die now.
  2. C

    Solved Variable not defined

    I get what you're saying but you didn't actually change anything from message #6 and I still get "Variable not defined".
  3. C

    Solved Variable not defined

    The purpose here is to go to sfcInvItem.Description. When adding a new invoice I want items and not receipts.
  4. C

    Solved Variable not defined

    Will this help...?
  5. C

    Solved Variable not defined

    Public Sub FormFocus() Dim sf1 As Form Dim sf2 As Form Set sf1 = Me!sfcInvoice.Form Set sf2 = sf1.sfcInvItem sfl.SetFocus sf2.SetFocus sf2.Form!Description.SetFocus same error; same place Although this error (and code) is on the sfcCustDetail, this form is a subform of a main form...
  6. C

    Solved Variable not defined

    Still same error. sf1 is a subform control and the form in the control has the same name
  7. C

    Solved Variable not defined

    Public Sub FormFocus() Dim sf1 As Control Dim sf2 As Control Set sf1 = Me!Form.sfcInvoice.Form Set sf2 = sf1.sfcInvItem sfl.SetFocus sf2.SetFocus sf2.Form!Description.SetFocus Set sf2 = Nothing Set sf1 = Nothing at sf1.SetFocus I get a Variable Not Defined error This sub is called...
  8. C

    jumpy record selector

    Arnelgp... Your code fixed the jumpy problem. Thank you so much!
  9. C

    jumpy record selector

    Sorry, it shows all invoices for the customer. Click on the invoice and it shows the detail. Click on preview and it prints it out. No fuss. I only wish it wouldn't jump back to the first after selecting another. I shall try arnelgp's code. Just look at it once. By the way, I did look at yours...
  10. C

    jumpy record selector

    Why? This works! Did you look at it?
  11. C

    jumpy record selector

    I followed your instructions. It works and I thank you. However, I need to see detail on the other invoices from the same customer. How would I do that? This works, not? Don't you just hate it when people don't follow the rules?
  12. C

    jumpy record selector

    Click in bottom subform to change invoice record.
  13. C

    jumpy record selector

    I have a subform with record selectors. The following is the form on click event: Private Sub Form_Click() Dim rs As Recordset Set rs = Me.Parent.RecordsetClone With rs .FindFirst "InvoiceID =" & Me.InvoiceID If Not .NoMatch Then Me.Parent.Bookmark = rs.Bookmark End...
  14. C

    Tab through subform

    Wow! You went above and beyond. I design patterns for individuals. Thank you for your work. Completely unexpected! Is the bottom list of invoices a report? Is it in the footer?
  15. C

    Tab through subform

    Now I remember... I had to do that to keep it a continuous form. I didn't realize it would mess up my tabbing. Back to the drawing board... Thank you for your time.
  16. C

    Tab through subform

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

    Tab through subform

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

    Tab through subform

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

    Tab through subform

    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)
  20. C

    Tab through subform

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