Search results

Command button placed on main page of frmPatientRecordbyLName. Private Sub Command173_Click() sfmPsychosocial.Form.Requery End Sub I went into the Psychosocial tab for a patient (who did not have a record) and entered an address, then I flipped back to my main tab and clicked the button...

Hmmm. I must be doing something else wrong then, because I have to completely close out of the main form, not just move to a different tab within the main form (so away from sfmPsychosocial) to get those calculated dates to show up. No, I'm only doing the calculations on the subform. Are you...

My main form controls are bound and they are updating when I update the EvaluationDate. The problem is that when I have an existing patient (who did not have a Psychosocial entry) or a new patient and I click on the Psychosocial tab - to get to sfmPsychosocial - it does not pull the EDC or...

Your explanation makes sense, except that the fields my users will be updating on sfmPsychosocial are NOT the fields that are involved in the calculation. Basically, my Psychosocial form captures an address and phone #, as well as checkboxes (to show completed contact with patients), and...

Thanks for the response, RuralGuy. You are correct that the RecordSource for sfmPsychosocial is a query of tblMaternalInfo and tblPsychosocial. I had originally been calculating the values of the expressions on the form instead of in the query. I went ahead and altered the query to perform...

Sorry in advance - this is long I have a database in which I maintain information about patients. I am having problems getting the results of several calculations and "pulled" fields to display without closing the form and re-opening it. tblMaternalInfo - includes demographic info, as well...