Search results

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.

Hello, I am using the following function: =Avg(IIf([Final]="TST-TST OK RTN" Or [Final]="NFF-TST & NFF" Or [Final]="RTN-RETURN" Or [Final]="SCL-SCR LOCALLY" Or [Final]="SCR-SCR RETURN" Or [Final]="BER-BER RTN CST",Nz([Cost Of New],0),0)) I have a subform with a total of 18 records. 2 records...

Yes, it was. This is a different question. Thanks, this worked!

I am trying to sum a column on a subform named Cost of New if another column named Final = any of the values listed in my code. However, it is summing the Cost of New column regardless of the values of Final. It is summing for all values. What do I need to modify to make this correct or...

That worked. :D Just curious, why do you have to put * -1?

Thanks to both of you. I opted for the second option since I am not good at code. I tried =IIf([Final]="RPR-RPR & RTN",Count(*),0) but that is giving me the count of all records if there is only one record where Final = "RPR-RPR & RTN). However, I don't need the total count, I only need...