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 derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: DSGF
  • Order by date
  1. DSGF

    Command button to open subfrom.

    Hi TeqGirl, I don't know the answer to your question, but you might get more responses after you check out the following links. Good Luck. FAQ219-2884: FAQ181-2886:
  2. DSGF

    Filter form based on subform

    PHV, You were absolutely correct. The answer was: stLinkCriteria = "EmployeeID In (SELECT PersonID FROM Responsibilities WHERE RegionID=" & Me!Combo7.Value & ")" My rookie mistake was using EmployeeID in one table and PersonID in the other table. Thanks again for your help!
  3. DSGF

    Filter form based on subform

    Ok. Thank you MajP that link helps me understant In vs WHERE. Do you know... Does it make any difference that the two tables are completely seperate and are only related by the form EmployeeID and the subform EmployeeID?
  4. DSGF

    Filter form based on subform

    OK, Here's what happended. I replaced: stLinkCriteria = "[RegionID] = " & Combo7.Value with.. stLinkCriteria = "EmployeeID In (SELECT EmployeeID FROM AAA_Responsinilities WHERE RegionID=" & Me!Combo7.Value & ")" When I press Command6 the form does open but shows me all 100 employees instead...
  5. DSGF

    Filter form based on subform

    Thanks PHV. I will try this and respond shortly. What is that "In" called. To better understand why this works, do you have a suggested keyword or topic that I could search on?
  6. DSGF

    Filter form based on subform

    Hi All, I am trying to open a form with a subform and filter the main form based on whats been assigned in it's sub-form. I have four tables Employees Region Channel Responsibilities EmployeeID RegionID ChannelID ResponsID LN Region Channel...
  7. DSGF

    combobox selecting wrong record

    Skip, Thanks very much for your helpful advice. I am new to Forums and did not even notice the Thank link. Thank you for pointing me to it. I did go ahead and thank ck1999 and will thank others as I go. Another question. When a question is answered, should I somehow close the thread? How...
  8. DSGF

    combobox selecting wrong record

    Yes, That's AND is exactly what I needed. Thank you very much ck1999!
  9. DSGF

    Combobox does not find correct record

    Perfect. I originally tried AND but my syntax was wrong. Thank you VERY MUCH!!
  10. DSGF

    Combobox does not find correct record

    I have created a form with two comboboxes. One selects company Reps by zip and the other by city. Zip combo works fine because there is always only one zip. There can be several like city names so in my City combobox I show city, county and state. However, whenever a city is selected, it...
  11. DSGF

    combobox selecting wrong record

    ok, I tried this... Set rs = Me.Recordset.Clone rs.FindFirst "[PO_NAME] = '" & Me![Combo60] & "WHERE [ST_ABBREV] = " & Me.Combo60.Column(3) & "'" Me.Bookmark = rs.Bookmark but this did not work either. It simply returns the 1st record in the table as if I did not enter any critia at...
  12. DSGF

    combobox selecting wrong record

    I have created a form with two comboboxes. One selects company representatives by zip and the other by city. Zip combo works fine because there is always only one zip. There can be several like city names so in my combobox I show city, county and state. However, whenever a city is selected, it...
  13. DSGF

    form1 Command Button to open form2 and filter subform

    TheAceMan1, Your code makes perfect sense. Thanks very much for your help. DSGF
  14. DSGF

    form1 Command Button to open form2 and filter subform

    Hi all, I want a command button in form#1 to open form#2 and filter it's subform. My form#1 [Reps_by_Zip] Command Button already opens form#2[Lut_Region] and filters it correctly, but I want it to filter form#2's subform [Lut_Employee] as well. There are several of these Buttons on form#1 and...
  15. DSGF

    DISTINCT combobox filter help

    Your Great! That was it. You can tell I'm a newbe. Thanks for your help!!
  16. DSGF

    DISTINCT combobox filter help

    Thank you MajP I did think this was the reason so I tried SELECT DISTINCT Reprsentatives.State and the box shows up empty. Interestingly it seems to now have just 3 spaces in the drop down but no text is displayed. Any thoughts?
  17. DSGF

    DISTINCT combobox filter help

    Ok..., I'm going nuts. I have a larger project that I can't get to work, but for the sake of simplicity I have made a basic test that is still not working. I have s table called Personal Personal contains ID, FN, LN, Street, City, State, and Zip. Personal contains 10 records, 3 from NJ, 5...

Part and Inventory Search

Back
Top