Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by JaineyBlue

  1. JaineyBlue

    Cascading combo boxes in subform

    Thank you for the help so far!
  2. JaineyBlue

    Cascading combo boxes in subform

    I attached a link to a somewhat stripped down version of the database. I have tried a bunch of different things, including what you have suggested to get these combo boxes working. The subform is fsubAutomLoc and i want it to work in three main forms that it is embedded in (the buttons...
  3. JaineyBlue

    Cascading combo boxes in subform

    On the .Clear I am getting compile error Method or data member not found
  4. JaineyBlue

    Cascading combo boxes in subform

    The table is similar to what you have, except in section 2 where each section is unique. But the code above is essentially what I had to begin with. My problem is this is a subform that is embedded into 3 different main forms, so if I choose the Branch in one main form it doesn't work in the...
  5. JaineyBlue

    Cascading combo boxes in subform

    If the info in the combo boxes is from the same table (costcentrestbl has fields named Branch, Department, Section1, Section2) do I need to identify Table.Field in the module? Getting a compile error "Argument not optional" in the subform code where calling the subroutine.
  6. JaineyBlue

    Cascading combo boxes in subform

    Still working on this damn vehicle database and need help with combo boxes please! Have three forms - Vehicles, Trailers, Equipment. Each of the forms has embedded subforms, one being Location [subAutomLoc], which has the user group info for each vehicle. The user group info is 4 cascading combo...
  7. JaineyBlue

    DLookup with criteria

    Thank you! This worked.
  8. JaineyBlue

    DLookup with criteria

    I inherited a vehicle tracking dB and trying to make some updates. Have a 'Tbl-Types' which lists vehicle, equipment and trailer types, as well as chassis types (Field1 combobox has 'A','V','E','T' choices). I want the vehicle form to autofill a fleet plan code (VWOCode) for each unit. Form...
See more

Part and Inventory Search

Back
Top