If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Opening one form based on 2 criteria in another form
I have a general form that contains patient information. In this form I can
scroll through different exam dates for a particular patient. I need to be able to open a second form (for editing) based on two criteria, patient ID and exam visit date. I have used open args before to open a form when only one criteria was being passed, howeverm, I can't figure this one out. Any help would be appreciated. Thanks. |
#2
|
|||
|
|||
Opening one form based on 2 criteria in another form
kejo41 wrote:
I have a general form that contains patient information. In this form I can scroll through different exam dates for a particular patient. I need to be able to open a second form (for editing) based on two criteria, patient ID and exam visit date. I have used open args before to open a form when only one criteria was being passed, howeverm, I can't figure this one out. Any help would be appreciated. Thanks. You're opening this from a button, right? Then in the button's click event, you have something like Sub cmdOpenSomeOtherForm_Click() Dim strFilter as string strFilter = "[PatientID]=" & Me.cboPatientID & " AND [ExamDate]=#" & me. txtExamDate & "#" docmd.OpenForm "MyForm",acNormal,,strFilter,acFormEdit,acWindowNo rmal End Sub -- Message posted via http://www.accessmonster.com |
Thread Tools | |
Display Modes | |
|
|