Search results

I have a button on my switchboard that when clicked runs a macro that I have created to open my form in "Add" Data mode. It worked fine until we put the database on the network and split it to a front end and back end database. Now when you click the button on the switchboard the Detail part...

I have a main form (frmIandRSurvey) with combo box for Status (Yes/No). I have four subforms and on each subform I have a combo box (Yes/No) that has code on the After Update as follows: Private Sub Returned_Call_After Update() If Me.Returned_Call = "Yes" Then...

I have a form for client satisfaction surveys. When an information call comes in it is logged in the form and we ask if we have consent to do a questionnaire. In my "On Current" Event of my main form and the "After Update" event of the Consent Obtained combo I have the following code: If...

I was able to use coding for making controls visible or not in the attached database. I have a main form with a tab control that has 3 tabs with subforms in them. What I am not able to do is in the Tab Control I want the 3rd tab to be invisible and on the second tab where it says “May we go...

Hi All, I have a main form and 5 tabs within that mainform that are subforms. They are linked by an EventID. The subforms are continuous forms, but only one record is "required". What kind of code do I need to make sure that the data entry person enters at least one record in each subform...

I have searched this site and tried several things over the last 3 days and am getting frustrated. All of my forms are built from existing tables. I have a main form (frmevent) with the primary key being EventID. I have many "continuous" subforms e.g. event type, initial action taken, initial...

I have a main form with many subforms. The sub forms are all continuous but one and I want the editors to be able to put in more then one record if needed. My problem is I have my tabs set up so that when the box is empty it will tab to the next subform. When I do this, a extra blank record...

I have search the forum and have found many solutions to this same problem but so far none have worked for me. I am fairly new to Access so maybe I am just not understanding properly. I have a form with a main form and many subforms. All subforms but one are continuous and the other is a...