okay, I have a form called tblpatient that hosts a subform called tblBill, this table bill has a subform that is called tblMedication, it is shown in attachments,
now, I've created another form that is called tblanalysis, I want to link it via a button or toggle click, so it will act like a subform where it will link BillID from tblBill with BillID from tblAnalysis,, how do I do that? I know how to to it using form wizard but I don't want to start from zero with the form.
I've created another one using the wizard, copied and pasted code, but the toggle or button exists in the patient form and didn't work (didn't open the tblanalysis form), In addition when I tried to put the toggle in the tblBill form where it is supposed to be, it didn't show me a button, see the attached picture and you will find a field called togglelink, which is supposed to be a toggle!
here is the code that didn't work when the toggle was in tblpatient form
On Error GoTo ToggleLink_Click_Err
If ChildFormIsOpen() Then