Hi,
I have a continuous subform that loads automatically with the form, and the subform contains a button to open it in a new tab, how can i make that when it opens the button should change to: return to main form?
Thank you, it worked, this is what i did:
Private Sub Form_Current()
Me.medicaidcheckbox = DCount("*", "InsuranceList", "InsType Like '*Medicaid*' AND DrID=" & Nz(Me.DrID, 0)) > 0
If DCount("*", "InsuranceNotes", "InsuranceNotes <> null AND DrID=" & Nz(Me.DrID, 0)) > 0...
Thank you,
I have another question maybe someone can help.
on the same form i want to add a button that will pop up on the continuous form when it has info from another table, here are the details:
Link fields: DrID
Main form: DRNMzipexpand
subform name: InsuranceListsbfrm
name of table...
it worked great, this is what i did:
Private Sub Form_Current()
If DCount("*", "InsuranceList", "InsType Like '*Medicaid*' AND DrID=" & Nz(Me.DrID, 0)) > 0 Then
Me.medicaidcheckbox = True
Else
Me.medicaidcheckbox = False
End If
End Sub
Thank you!
i don't know how to make a test db:
here is the info i have will this work?:
Main form: DRNMzipexpand
subform name: InsuranceListsbfrm
on the subform Column name: InsType
on the subform Specific word: Medicaid
on the main form checkbox: medicaidcheckbox
Hi,
Is there a way to do this if a continuous subform contains a word?
subform name: InsuranceListsbfrm
on the subform Column name: InsType
on the subform Specific word: Medicaid
on the main form checkbox: medicaidcheckbox
When the subform contains that word it should tick the checkbox.
Thank you,
However i tried to use DCount(). but i think i'm new and couldn't get it to tick by itself on the main form on when i click that data field in the continuous form. maybe you can explain it better to me?
Hi,
I have a main form that has info of person and a few continuous subforms that contain info connected to that person, however i want a certain message to pop up or a checkbox should be ticked (whichever is more simple) evetime one of the continuous forms contain a specific word.
What boud be...
thank you, it looks great however i'm new to vb so i can't understand it so well, i need a better tutorial on the code so i would be able to implement it for my DB. (beside the coding, i'm not sure why there are so many labels?).