I have two forms:
- PatientConsultsForm (PatientForm + subForm ConsultDetails
- DispenseForm
On the PatientForm I want a “Push Button” that will open the DispenseForm for the specific PatientID/ConsultID. How do I accomplish this.
I have two forms:
On the PatientForm I want a “Push Button” that will open the DispenseForm for the specific PatientID/ConsultID. How do I accomplish this.
You’ll need to write a macro and attach it to the push button event. The macro will need to open the Dispense form with a filter that uses the specific PatientID/ConsultID. I’m assuming your form is a database form. You can find out about opening forms like this by consulting the Access2Base website which has examples of code snippets that will help.