displaying last entry

[borg]

I am building a db where I can view clients and make a quotation is there a way where I can view the last quotation number I have enterd

 

[dcx693]

Where are you viewing them? On a form? Use a form of the Dmax or Dmin function if you've got some way of tracking in which order items were entered.

 

[sachinchopde]

Dear All
I am very new to the Access and the forum. I need urgent help. I have form in which I have one of the x field which is disabled and is enabled when criteria met from the other y field, i want to make the the the x field required ( non null) only when enabled. How can I do that

 

[nanscombe]

You could use the form's BeforeUpdate event to do that.

Private Sub Form_BeforeUpdate (Cancel as Integer)
  If x.enabled = TRUE Then

    If Len(x & vbNullString) = 0 Then
      MsgBox "Field 'x' is required. Please enter a value"
      Cancel = TRUE
    End If

  End If
End Sub