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