troubleshooting Question

Copy Value from ListBox to a bound Text box on subform

Avatar of johnberniejones
johnberniejones asked on
Microsoft AccessSQL
41 Comments1 Solution614 ViewsLast Modified:
I have a problem with a query I am using for a subform.
The main form has an unbound listbox (lstConsultDate) that displays tblConsult, this is bound to another lstbox from tblClient. When I select the Client, it displays the consultations for that client that do not have a payment attached. I am using this to follow up on any outstanding accounts.

I have a subform for tblFollowUp (frmFollowUp subform) which I have on a subform. I want to select the lstConsultDate lstbox and automatically populate a value in the frmFollowUp suborm's textbox.  

There is a checkbox in the tblFollowUp called PaymentReceived. When this is checked I would like the lstConsultDate to no longer display the date. I know there are alot of questions here but I would appreciate any help

Thanks

SELECT tblFollowUp.Consult, tblFollowUp.RequiresFollowUp, tblFollowUp.[Contact Client], tblFollowUp.SendLetter, tblFollowUp.Comments, tblFollowUp.PaymentReceived, tblFollowUp.DateEntered FROM tblFollowUp INNER JOIN tblConsult ON tblFollowUp.Consult = tblConsult.ConsultID WHERE (((tblFollowUp.Consult)=[Forms]![frmFollowUp]![lstConsultDate]![Column(1)]) AND ((tblFollowUp.PaymentReceived) Is Null));  
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 41 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 41 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros