Recent content by rhonda6373

Thanks DBguy. That will work for this purpose.

I have an option group (optResponse31) that has 3 buttons. I want a message to pop up when the user clicks on the form by clicking the X on the top right of the form. I want the message to state "Please enter a value." if no value is entered. I tried to set the required property in the...

DBGuy, that worked perfectly. Micron, I do appreciate your suggestion! However, I was thinking that since the claims form is not always open, there would not be a way to trigger it. I think it is a subform, but is not embedded in the main form. You have to click a button to open it.

Thanks, Micron. I had seen DBguy's post first and tried his method which worked. I am going to try your method as well to see if that works. I will let you know.

Woo hoo! This is awesome -- it does work. I put it in the OnCurrent event of frmBankruptcy. I do have one more question. I have frmBankruptcy open. I click the button to go to frmClaims. I change the value of CL_DEPT to THDA dba Voluntary Mortgage Loan Servicing on one of the claims. I exit...

The record source for frmClaims is a table named Claims. Thanks.

I am attaching screen shots.

Thanks theDBguy! I was going to try the onCurrent and AfterUpdate. My issue is they are two different forms. I am trying to evaluate the value(s) (Note: may be multiple) on one form to determine whether to make the label visible on the other form. Form 1: frmBankruptcy. This is the form I...

I am a beginner, so keep that in mind :confused:. I am actually a Business Analyst and not a developer. I have an issue with a database that has two forms: frmBankruptcy and frmClaims. I think frmClaims is a subform. The forms are joined on CaseID. There is one Bankruptcy case to...

Hello all, I am not a developer, but a Business Analyst. The limits of my Access knowledge were from a class taught almost 20 years ago, so I am looking forward to getting help here. I have a few questions. Please forgive me if I am not asking them in the right place and let me know...

I am not sure what I was doing differently than yesterday other than slept. I must have been binding the control incorrectly. At any rate, binding the control with the approach mentioned in my first post worked! Thanks for all of your help and I appreciate your time! Rhonda

If I bind the combo boxes, then how can I filter the division combo box to only show the divisions that are associated with the section that was selected?

First, I am a novice at Access. I have the following question: I have a database of attorneys. The attorneys detail table has a column named section and division. Each attorney is assigned to a section and division. The divisions are a subset based on the section selected. I need to...

I am getting an invalid syntax. Can you help? =Sum(If([Final]="TST-TST OK RTN"), Nz[Billed], 0) / Sum(If([Final]="TST-TST OK RTN"), 1,0)

Thank you so much! I would have never gotten that. I will try it.