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
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));