Search results

Hello everyone. I have a main form with many subforms. Each subform has couple of ComboBoxes or/and TextBoxes. I want to make sure that end users dont miss completing any of required values. For example, in the subform (Clients), an end user is supposed to put either "Male" or "Female" in the...

Thank you Steve for your reply and suggetion. Surely I will consider this. But I thought there is another way or code to use the same form. By the way, the main form has couple of subforms and tabs which show different records and info of one client/person at one time. Thats why I prefer not...

Hello everyone.. I have a form which needs update ever month. When the form is pened, the end user can see the old records and data, and also a new recored is added for any new data. I want to protect the old saved data and the user can only add, edit, or delete the new data in the newly added...

Hi Bob.. Sorry for any confusion. Let me walk you through this: When you the db I sent, and open the form (frm_Cases), there are 2 cases (families), the 1st family has 4, and 2nd one has 3. In the 1st family, John Doe (the hasband) got two jobs, and lost them later. His third job started on...

Hello Bob, I attached the db file in this post. I made it very simple. There are 2 tables and 3 forms. The form (frm_Cases) is the main form to open the DB where you can use and try the subform (JobInfo) where you can add as many records as you want of job info to the same person in the same...

Oh! Good to know. I will post the db soon. Thank you Bob.

Bob, how can I post (attach) a copy of the db??

Hello Bob.. I have one more question related to my one yesterday but with a different scenario. The same subform we were talking about yesterday has also 2 CheckBoxes (Job Stop) and (Retention), and 1 TextBox (Date of Job Stop) which might not be required for every record. Here are more details...

It works well now. Thank you so much Bob for your help and experience. You are the man.

Thank you Bob for your reply. It helps but still have some errors. I added only your first code related to (Employer Name) starting with the line: If Nz(Me.[Employer Name],0=0 Then It works only when I put the value (0) as the Employer Name. If I put any other value like (Walmart), and when...

Hello everyone, I have a main form which has couple of subforms bound to one main table. One of the subfomrs is about employment info. It has 3 TextBoxes: (Job Start Date), (Employer Name), and (Wage). It has also 3 ComboBoxes: (Job Type [Full Time or Part Time]), (Hire Status [Permanent or...