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!

Search results for query: *

  • Users: fazm
  • Order by date
  1. fazm

    Datasheet Subform: trying to get combo box to populate another field

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

    Datasheet Subform: trying to get combo box to populate another field

    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)...
  3. fazm

    Datasheet Subform: trying to get combo box to populate another field

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

    Form RecordSource Question

    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!!
  5. fazm

    Form RecordSource Question

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

    Using Query For RecordSource

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

    Using Query For RecordSource

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

    Put Results From Qry into MsgBox

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

    Taking ComboList Items & writing a qry to select records randomly

    Thanks scriverb! I will give it a try. Fazm
  10. fazm

    Taking ComboList Items & writing a qry to select records randomly

    Its on the way Rolliee, Thanks!
  11. fazm

    Taking ComboList Items & writing a qry to select records randomly

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

Part and Inventory Search

Back
Top