Search results

Thank you, I figured it out: in the form load i set the visible to true and in the subform load i set the visible to false.

LOL, i need to do what i can to get some help.

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!

Hi, Thank you, i'm still new at this, you think you can help with the code?

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!

wow, Thank you Yes this worked like a charm...onto the next step...

The link is: DrID name of table: InsuranceList

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?).

thank you, i just added the hide shrink to the buttons. also is there a way to make it adjust to a continuous form?

Thank you Isla, that's a huge help, also is there anyway to add that when the 2nd btn is pressed the 1st one collapse?

Thank you, that will be a great help. looking forward.

Yes i looked at it many time and i couldn't figure out how to do it, i have a continuous form not a datasheet, also the subforms are around 7/8 different ones that will be expanded independently, that's why i need to know how they can align when collapse, and move down when expanded..

Thank you, i was asking on the original post. however anyone who can help would be a huge help for me.