Recent content by Bob M

  1. B

    Dlookup

    DLookup Thanks Kevin. That worked. Keep up the good work.
  2. B

    Dlookup

    DLookup PreviousOwner is not on the parent form, it's on the same form as the control.
  3. B

    Dlookup

    I have a control on a subform whose control source is: DLookup("[FullName]","tblUserInfo","[EmployeeID] = " & Me.PreviousOwner) PreviousOwner is a longInteger and EmployeeID is an autoNumber. On another form when ownership of equipment changes hands, I simply pick another user from a...
    • Bob M
    • Thread
    • Replies: 4
    • Forum: Forms
  4. B

    Passing Combo box value to another form

    Passing Combo Box Value Thanks Kevin. That did it!! I modified the code for opening the entry form and it worked beautifully. Thanks to you also Wayne. You people are great!!!
  5. B

    Passing Combo box value to another form

    Passing Combo Box Value This is hopeless. I've deleted everything except the form, subform and entry form and the zipped file is still 179k. I've also stripped the form of everything except the opjects needed to see the problem.
  6. B

    Passing Combo box value to another form

    Passing Combo Box Value I have stripped down the database to it's bare minimum. It is now compacted and zipped down to 256k. The maximum for posting attachments here is 102k. Is there any way I can e-mail this to you directly.
  7. B

    Passing Combo box value to another form

    Passing Combo Box Value I have deleted a whole lot of data from all tables and gotten rid of everything that was not essential to the system. I converted it to Access 2000, compacted it and zipped it and it's still 1.5mb.
  8. B

    Passing Combo box value to another form

    Passing Combo Box Value Actually I have Access 2002. The utility is compact and repair. I did that then zipped it and it's still 1.5mb.
  9. B

    Passing Combo box value to another form

    Passing Combo box value I can zip it but I don't think I can compress it. The entire database zipped is 1.7mb.
  10. B

    Passing Combo box value to another form

    Passign Combo Box value Wayne No, I don't. Bob From the land of the frozen chosen
  11. B

    Passing Combo box value to another form

    Combo Box The VendorProductNo is not an autonumber. I tried putting it in the rowsource to no avail. I should mention that I have a brforeupdate procedure that does a Dlookup on the Prodcts table using VendorProductNo. I tried assigning this value to Me.VendorProductNo just before doing...
  12. B

    Combo Box Requery

    Here is the code taken from this site btw. Private Sub ProductID_DblClick(Cancel As Integer) On Error GoTo Err_ProductID_DblClick Dim lngProductID As Long If IsNull(Me![ProductID]) Then Me![ProductID].Text = "" Else lngProductID = Me![ProductID]...
  13. B

    Passing Combo box value to another form

    I have a combo box on a subform. When I enter a value in the combo that is not part of the list I want to launch another form where the user enters the new product. I would like to capture the value entered and pass it to the next screen so the user doesn't need to enter it twice. Since the...
    • Bob M
    • Thread
    • Replies: 15
    • Forum: Forms
  14. B

    Cascading Combo Problem

    Sorry Kevin, but I've already tried that as well. Funny thing is that I can see the Product Descriptions for only one supplier. I've looked at the records of that supplier vs other and can't see any difference. I'll keep plugging, there has to be an answer to this.
  15. B

    Cascading Combo Problem

    Thanks people, but I've already tried both. The problem is not when I add a new record. It's when I view existing records. This gets better still. I another path into the same form filtered through a form that allows the user to select a supplier then look at open and closed POs. Everything...
See more
Top Bottom