Search results for query: *

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:

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!

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?

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...

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?

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...

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...

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

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

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...

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...

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...

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

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...

Your Great! That was it. You can tell I'm a newbe. Thanks for your 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?

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...