Search results

  1. C

    How do you: Populate Form Field From Query?

    Awesome! This will work wonderfully! I do have some exceptions with the way Reps are assigned so if the result set has multiple choice then at least the user can make a choice. Thank you!
  2. C

    How do you: Populate Form Field From Query?

    I think the attachment will work to show the form, table, query
  3. C

    How do you: Populate Form Field From Query?

    JR I am really thankful you are helping me; I am not sure what you mean for me to try. I agree; My goal is not to write to the form but to the table Rentsys_CallLog but I do want to have the query (execution) display the "REP" in the form field. So in order to do this the query needs to find...
  4. C

    How do you: Populate Form Field From Query?

    Ok; trying the UPDATE type on the query and entering "Forms!Rentsys_CallLog.SalesRep" in the Update To: under field "rep" caused not my form field "SalesRep" to contain the "rep" but it is updating the table sales rep by blanking out the rep that would have been the correct one: UPDATE...
  5. C

    How do you: Populate Form Field From Query?

    I have the WHERE part from the user entered data in th form and the query is returning the information I need, however I need to bridge my learning gap on how instead of selecting the result to view, get the result inserted into the form field.
  6. C

    How do you: Populate Form Field From Query?

    How do I update or append my form field to get the results from the select statement (query)? Would the query be Update "form?" Set [SalesRep] = [Rep] FROM FROM (RentsysReps LEFT JOIN LetterAssigned ON RentsysReps.ID=LetterAssigned.RepID) LEFT JOIN StateAssigned ON...
  7. C

    Combo Box update based on query

    is there a join in the query, you may need to use a left outer join and not an inner join
  8. C

    How do you: Populate Form Field From Query?

    So I have a form that has a text box called [SalesRep] a button when clicked runs a query from parameters entered in the form which results in a new window with a single field/record [Rep]; I have fumbled around for days trying to google a solution becasue I do not know how to get the result...
Back
Top Bottom