Recent content by oMADMANo

okay I have a text box set up and formatted for date called RenewalDate and I would like it to show up a reminder if this is current date or more. I have tried this If RenewalDate.Value < Date Then OLEUnboundRenDte.Visible = False ElseIf RenewalDate.Value >= Date Then OLEUnboundRenDte.Visible...

Solved. I made the form "Risks" a child form and then used Private Sub RiskButton_Click() Dim cr As Integer cr = CurrentRecord DoCmd.OpenForm "MembershipChildRisk" DoCmd.GoToRecord acActiveDataObject, frmPatents, acGoTo, cr End Sub

1. Open the form 2. Find the MemberID and move to that record 3. But still show other members if you click Next or Previous record could work.

okay so I have set up a new form and I have combo boxes on. It has created the columns in my datasheet but how do I make that column a control source. Any help appreciated as I am stuck on this one.

If you wouldn't mind then yes maybe I cant seem to get that code to work because like I said I don't have the me.MemberId set up just a number for the record. Thanks

Sorry for edit i used This instead Private Sub RiskButton_Click() Dim rs As Object Dim RiskBookmark As Long 'set a variable to the current record RiskBookmark = Me.txtMemberID 'open the new form DoCmd.OpenForm "Risks" 'take it to the selected record Set rs = Forms!Risks.RecordsetClone...

I do have a first form with all members details but i want the 2nd form only to have the members name as title and then have more options which are from the template I made.

Im sorry i didnt mean it like that , i just meant if any one could provide some additional information on this as i am still a bit stuck. Thanks

any1 else help with button function plz ?

Thanks that helps for the title. Just stuck on the button now. Im thinking something like: Private Sub RiskButton_Click() DoCmd.OpenForm "Risk(Me.MemberName.Value = FirstFormName.MemberName.Value)" End Sub Wich would create a risk form for that member as i dnt need risk forms for every...

Hi im fairly new to all this codeing in access but i think this is possible. I have put together a simple database for my members for me to view all there information but i would like to be able to have a 2nd form open only for some members with a button that would have more option boxes. so...