Search results for query: *

Thanks Ken for all your help. Got it to work. The actual subform control was renamed and I didnt catch it. I kept looking at the subform properties and the name of the subform itself, not the actual subform control itself when selcting it in design mode. So I was never getting the name of the...

Ken - Thanks for the quick response. I do know that sfrmService is the name of my subform and the control would be the text box called ServiceNm on that subform. It looks like I am not getting the syntax correct. Could you provide me a sample to identify my control (textbox called ServiceNm)...

I have a form called frmClientTracking, within this form is subform called sfrmService. The subform (datasheet view) consists of ServiceCd and ServiceNm, etc. ServiceCd is a pulldown list populated from another table via the row source control, when a certain number is selected, I want to...

Thanks for the lightning fast responses, each one was very helpful and now I can tackle this from different angles. You guys are the best...thanks again!!

I have a query that is creating the record source for a form (form_load event): strSQL = SELECT a.ClientID, a.ClientFirstNm, a.ClientLastNm, b.EmployeeFirstNm,b.EmployeeLastNm, b.CaseLoadID FROM tblClient AS a, tblEmployee AS b WHERE a.CaseLoadID=b.CaseLoadID And ClientID=[Enter Social Security...

Thanks CajunCenturion for the quick response!!! It worked perfect!! I was making it to hard on myself!! Thanks again!

Can anyone give some insight to this: I have a query: SELECT a.ClientID, a.ClientFirstNm, a.ClientLastNm, b.EmployeeFirstNm, b.EmployeeLastNm, b.CaseLoadID FROM tblClient AS a, tblEmployee AS b WHERE a.CaseLoadID=b.CaseLoadID And ClientID=[Enter Client ID]; This is being used as the...

Platform: Access 2000 Qry: SQL query within VBA I want to write a select qry and have the results displayed in a msgbox. Is this possible? Also, can the result be used in another qry. I am gathering that I may need to do this with via recordset, but I dont know how to set that up. Any help or...

Thanks scriverb! I will give it a try. Fazm

Its on the way Rolliee, Thanks!

Help! I am on the verg taking a sledge hammer to me PC! I have a form with a combolist on it with 3 items to choose from. Based any one of these items, I need to randomly select a match from another table and then display it either in a datasheet or msgbox. I know SQL pretty good so I was...