Recent content by depawl52

  1. D

    Combox Issue

    Thanks so much for the input and suggestions guys. Your proposed solution(s) appear to work perftectly.
  2. D

    Combox Issue

    So my pared down sample db is attached. As you can see in tblInvoice there are 2 existing Invoice Numbers (00001 and 00002). And in tblInvoiceService, there are 2 InvoiceServiceID's (996 and 994) with no Invoice Number yet assigned. So upon opening NewInvoiceF and entering Invoice Number 00003...
  3. D

    Combox Issue

    So sorry. The invoice number is entered manually. The user is given the last sequential invoice number on the form. For example, the user is given Invoice Number 00003 and told to enter the next sequential number. I realize this is not optimal, the next thing on my list to fix. Still trying to...
  4. D

    Combox Issue

    I have a database for a small repair shop. When repairs are made, staff members enter a service ticket, which has a Service ID autonumber. At a later date, this Service ID # is added to an Invoice. The Invoice Number is not an autonumber (not my design or choice). This is done on a form with a...
  5. D

    me.dirty

    Thanks Pat. That's kind of the way I've been leaning, but my approach is pretty much bungling trial and error to get to the code you provided. Much appreciated.
  6. D

    me.dirty

    Greetings all. I have a main form and a subform. On the mainform, when a user enters data, the "Save Record and Return" Button has the typical code: If Me.Dirty = True Then If MsgBox(" Save Changes? ", vbYesNo) = vbYes Then Me.Dirty = False Else Me.Undo...
  7. D

    Double Lookup Problem

    Thanks for all the responses. Just as an fyi, this is a database that I (more or less) inherited and was trying to do repairs and make some improvements. I've never used a lookup for all the reasons stated above, I was just hoping that in this instance there might be a quick fix, without having...
  8. D

    Double Lookup Problem

    Greetings and Happy New Year all. I'm having a problem with using a Lookup to bring the Customer ID and Customer's name from a Customer's Table into a Products table. So in the Products table, I have a lookup field: SELECT tblCustomer.CustomerID, [Lastname] & ", " & [Firstname] AS CustomerName...
  9. D

    Open Form to Blank Record

    Since my Query calculates a sum, average, count, etc. on the values in a field, I presume that it is not updateable. correct?
  10. D

    Open Form to Blank Record

    Thank you Pat. So assuming some field is CustID, and myform is named OrdersF, and the cbo is NameC, would the correct syntax be: CustID = Forms!OrdersF!NameC!CustID ?
  11. D

    Open Form to Blank Record

    Yes, in the query in datasheet view, I do get the message "Query is not updateable". Also entering DoCmd.GoToRecord , , acNewRec in the forms On Load Event gives a Runtime error '2105': You can't go to the specified record.
  12. D

    Open Form to Blank Record

    Greetings all. I have a simple form with one unbound (combobox) and 4 bound (test boxes) controls. The form has a query as it's control source. I need to have the form open to a blank record, but it opens to the first record. I've tried: Call DoCmd.GoToRecord(, , acNewRec) in the Open Form...
  13. D

    Solved Cascading ComboBoxes

    Thank you Mike. Your example appears to work perfectly. I haven't had time to import it into my production database yet but I have no doubt it will be fine. Thanks again .
  14. D

    Solved Cascading ComboBoxes

    Thank you for the input to date, which is always appreciated. I've uploaded a small sample database as an example of the issue I'm having. Due to requirements set by others I am unable to make any changes to the layout or format of the combo boxes on the "Customers" Form. So as you can see, if...
  15. D

    Solved Cascading ComboBoxes

    Greetings all. I have a Customer database with almost 20,000 records. There is a form with 3 cascading combo boxes to select the State, City, and Address in order to locate a specific customer. All the comboboxes work correctly, the only issue I have is that with this many records, some of the...
Top Bottom