Emply control check

[ibraomer]

I have a database for students registration, students pay their fees in installments, and receive a receipt, then I want when I enter the first installment then the receipt number which is below the first installment control can not be null.


have it here [if the first installment control contains the fees that the student has paid, then the receipt number control must have the receipt number not null]

[ibraomer]

Hi, I have made a program to register students, the students pay in installment, and whenever they pay they should receive a receipt. so in the form I have these fields student name, Fees, firstinstallment, receipt number second installment, receipt number ans so on. what I need is when I enter the first installment then the receipt number must not be blank even if I forget to do so I need access to tell me that you can't leave the receipt number field blank since the first installation field is not blank. does this make sense?

[ajetrumpet]

try something like:

if isnull(me.receipttextbox) then
   msgbox "receipt must be filled in because first installment is filled in."
      exit sub
end if

on an event of your choice.

[ibraomer]

I do appreciate what you did for me. your code works, but I still can leave the Receipt control empty. I want it to be as required but in case of the above field is updated with value. To make it clear I want you to modify the code to be like this: If the previous field which is the First installment is updated and contains values then the below field which is the receipt number must be updated with the receipt number otherwise I can't move the cursor to another field. I hope I am clear now! I am so sorry for my poor English.

[ajetrumpet]

you know one thing that is not mentioned very often when someone asks that data be 'required' is to do it at the table level and trap the error via the form.

to further this, let me propose this scenario to you:

I have a table that has a field in it, and I opened the table in design view and marked the 'required' property to yes.

Now, I create a form from that table and the field is obviously still required. To trap the error that access will automatically throw to you if you try to save or enter the record without filling in data for that field, you can use:

ErrHandler:
   If Err.Number = 3314 Then
      MsgBox "Required fields must be filled in...", vbExclamation
   End If

try using that method, and the program will automatically required data there. No other code is needed if you know that this is available to you.

[ibraomer]

you know one thing that is not mentioned very often when someone asks that data be 'required' is to do it at the table level and trap the error via the form.

to further this, let me propose this scenario to you:

I have a table that has a field in it, and I opened the table in design view and marked the 'required' property to yes.

Now, I create a form from that table and the field is obviously still required. To trap the error that access will automatically throw to you if you try to save or enter the record without filling in data for that field, you can use:

ErrHandler:
   If Err.Number = 3314 Then
      MsgBox "Required fields must be filled in...", vbExclamation
   End If

try using that method, and the program will automatically required data there. No other code is needed if you know that this is available to you.

your efforts are appreciated. I opened the table in design view and marked the 'required' property to yes. this makes that field required all time but I want it to be required only if the field 'First installment' contains value. if the student didn't pay then no reason that the field 'receipt number' to be required.

[ajetrumpet]

sorry ibra. I've really already given you the answer to that. You'll have to figure it out on your own from this point

if you want to upload your file, someone may be able to look at it and fix it if it doesn't take too much time.

[ibraomer]

Is this close?

Private Sub Form_Current()
   If Me.Check1212 = True Or Me.Check1418 = True Then
      'all are disabled
      Me.cmd_delete.Enabled = False
      Me.Check1234.Enabled = False
      Me.Check111.Enabled = False
      Me.check116.Enabled = False
      Me.cmd_save_record.Enabled = False
      Me.enter_notes.Enabled = False
   Else
      'these are enabled
      Me.cmd_delete.Enabled = True
      Me.cmd_save_record.Enabled = True
      Me.enter_notes.Enabled = True

      'now eval Check111  & Check1234
      If Me.Check111 = True And Me.Check1234 = True Then
         Me.Check1234.Enabled = False
         Me.Check111.Enabled = False
         Me.check116.Enabled = False
      Else
         Me.Check1234.Enabled = True
         Me.Check111.Enabled = True
         Me.check116.Enabled = True
      End If
   End If
End Sub

Dear I made a program for students registration, the form contains the following fields: ID, Name, Fees, FirstInstallment, FirstReceiptNo, SeondInstallment, SecondReceiptNo.

Sometimes I forget to enter the receipt Number so that I want the system to force me enter the receipt number whenever the installment is entered. I tried to make this from the Table design view but this makes the field required all the time even if the student didn't pay the first installment. Please help me with the code. I want the code to force enter the receipt number only if the student have paid the installment because when the pays the he should receive a receipt.