About “Request Credit Report”

Posted by admin on October 18th, 2007 at 04:17pm

Q. frmNewSubmission has a subform frmApplicant.

Subform frmApplicant has hidden city state and zip data

and a button that lauches frmApplAddr.

frmApplAddr is a form where a user can fill in city state

and zip data.

The Form_Load() and Form_Current() events for

frmNewSubmission check to see if hidden city state and zip

data exist in frmApplicant.

If they exist a button called “Request Credit Report” is

enabled.

If they don’t the button is disabled.

However I needed code to check data entered in

frmApplAddr. As well.

If frmApplAddr’s city state and zip exist then it enables

frmNewSubmission’s button.

If not the button is disabled. I put this code in the

Form_AfterUpdate event

Here’s my problem. I noticed that if I have one applicant

in frmApplAddr, the Form_AfterUpdate() code works fine,

but if there are two applicants, i.e. two records,

the second record is ignored. What am I doing wrong.

A. I think that your basic problem here is that a button on a form can only

have one state. In other words it is either enabled or disabled. If you have

a continuous subform, I don’t believe that you can have a button that is

enabled on one record and disabled on the next. This is because it is the

same subform.

Now that I have said that, there may be a way to make it change as the user

goes to the record through enabling or disenabling using the OnCurrent

property of the form. That would mean when the user goes to that subform

record the button will change state at that point.

The button on frmNewSubmission will have only one state, I

just want the changes made on frmApplAddr to determine

that state. So when a person enters city/state/zip

information and closes frmApplAddr, the code I showed

should check all records entered to make sure city/state

zip/information exists. Currently it only checks the first

record, regardless of how many are shown in the form. If I

have Person A with valid city/state/zip, and Person B with

a missing state, my button shows as enabled when really

something is missing.

Under Uncategorized