Contingent Required Fields in a Form

[umuckatie]

I have certain fields that I need to be required based on a previous answer in a combo box. Here is an example:

If the user selects "deposit" from the combo box for "Reimburse By" then I need the "Bank Name" combo box, account number field and "account type" combo box to become required.

Is this possible and if so how do I do it. TIA

[NeoPa]

I believe it is possible.
However it's going to be very hard to help with so little information provided. Remember we only know what you tell us, and that, so far, is very little.
Please see (POSTING GUIDELINES: Please read carefully before posting to a forum) for help in formulating a question that will help us to help you.

MODERATOR.

[umuckatie]

I believe it is possible.
However it's going to be very hard to help with so little information provided. Remember we only know what you tell us, and that, so far, is very little.
Please see (POSTING GUIDELINES: Please read carefully before posting to a forum) for help in formulating a question that will help us to help you.

MODERATOR.

I'm using Access 2000 and have created a form for employees to use to submit expenses they incur. I have certain fields and columns that are required and other fields and columns that I need to be required if the employee selects "deposit" from the column. If the employee selects "check" from the column then those fields should not be required. If "deposit" is selected then I have one field and two columns that I would like to be required. The field label is "account number" and the column labels are "bank name" and "account type"

I hope that clarifies! Thanks for any help :)

[ADezii]

I have certain fields that I need to be required based on a previous answer in a combo box. Here is an example:

If the user selects "deposit" from the combo box for "Reimburse By" then I need the "Bank Name" combo box, account number field and "account type" combo box to become required.

Is this possible and if so how do I do it. TIA

Here is generic code that will not allow you to Save a Record if Deposit is
selected in the Reimburse By Combo Box and there are no values in one
or more of the Bank Name, Account Number, or Account Type Fields,
essentially making them required. Hope this is what you are looking for. It
resides in the BeforeUpdate() Event of the Form where the Update can be
cancelled should one of this conditions exist:

Private Sub Form_BeforeUpdate(Cancel As Integer)
If Me![cboReimburseBy] = "Deposit" Then
  If IsNull(Me![cboBankName]) Then
    MsgBox "You must provide a Bank Name"
    Me![cboBankName].SetFocus
      Cancel = True
        Exit Sub
  End If
  If IsNull(Me![txtAccountNo]) Then
    MsgBox "You must provide an Account Number"
    Me![txtAccountNo].SetFocus
      Cancel = True
        Exit Sub
  End If
  If IsNull(Me![cboAccountType]) Then
    MsgBox "You must provide an Account Type"
    Me![cboAccountType].SetFocus
      Cancel = True
        Exit Sub
  End If
Else
  'Do whatever
End If
End Sub

[umuckatie]

Here is generic code that will not allow you to Save a Record if Deposit is
selected in the Reimburse By Combo Box and there are no values in one
or more of the Bank Name, Account Number, or Account Type Fields,
essentially making them required. Hope this is what you are looking for. It
resides in the BeforeUpdate() Event of the Form where the Update can be
cancelled should one of this conditions exist:

Private Sub Form_BeforeUpdate(Cancel As Integer)
If Me![cboReimburseBy] = "Deposit" Then
  If IsNull(Me![cboBankName]) Then
    MsgBox "You must provide a Bank Name"
    Me![cboBankName].SetFocus
      Cancel = True
        Exit Sub
  End If
  If IsNull(Me![txtAccountNo]) Then
    MsgBox "You must provide an Account Number"
    Me![txtAccountNo].SetFocus
      Cancel = True
        Exit Sub
  End If
  If IsNull(Me![cboAccountType]) Then
    MsgBox "You must provide an Account Type"
    Me![cboAccountType].SetFocus
      Cancel = True
        Exit Sub
  End If
Else
  'Do whatever
End If
End Sub

Thanks for your help but I still can't get it to work.

It tells me "run-time error 2465' Microsoft access cannot find the field 'cboReimburseBy ' referred to in your expression"

What am I doing wrong? Am I supposed to change something??

[NeoPa]

I don't mean to speak for ADezii, but as a general rule you need to adapt any code for your own database.
Unless you ask your question very well (very few do :() then the expert won't know enough about your situation (particularly the names of your controls and fields etc) to put the right names in their offering. What you need to do is read the code and make changes where appropriate for your database.
If this is too complicated for you at this stage, then you could post the relevant details in your question and most experts will tailor it to fit.
HTH.

[ADezii]

I don't mean to speak for ADezii, but as a general rule you need to adapt any code for your own database.
Unless you ask your question very well (very few do :() then the expert won't know enough about your situation (particularly the names of your controls and fields etc) to put the right names in their offering. What you need to do is read the code and make changes where appropriate for your database.
If this is too complicated for you at this stage, then you could post the relevant details in your question and most experts will tailor it to fit.
HTH.

Thanks for the assistance. Sometimes I'll make assumptions about substitutions, renaming, etc. when I really should not. I try to do the best
with the information provided. BTW, you guys do a fantastic job with this
Forum.

[NeoPa]

Not a problem ADezii. And thanks for the comments.
I believe the best way to look after our members is to look after our experts.
We want as many members as possible, but the only way that will happen is if the experts keep things going. You experts are the valuable assets of the site. You can have a million members, but if you have no experts then you can bet there won't be a million members left tomorrow. Let me, or any of the other moderators, know if you have any problems (I don't expect you to have any - but if you do...).

[umuckatie]

Ok I tried to figure out what I needed to change and I couldn't do it. My drop down box is named "reimburse by" I tried putting a space in there and it still doesn't recognize it. I guess I still don't know what I'm doing wrong. What info do you need to help me? Thanks and sorry for being so clueless :(