Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2003
    Location
    Raleigh, NC
    Posts
    183

    Red face Unanswered: Navigation Button

    I have subform with "Navigation Button" Subform have about 10 fields. Now i have done all validation at tbl level and frm level. When user clicks on "New" command button and if some of the fields is not fill then i want to hightlight those fields to let user know that they need to fill that out before going to new records.

    Any idea how to do this ?

    Thanks in advance
    Skharva

  2. #2
    Join Date
    Jan 2004
    Location
    Kennesaw, Ga
    Posts
    20

    Re: Navigation Button

    Originally posted by Skharva
    I have subform with "Navigation Button" Subform have about 10 fields. Now i have done all validation at tbl level and frm level. When user clicks on "New" command button and if some of the fields is not fill then i want to hightlight those fields to let user know that they need to fill that out before going to new records.

    Any idea how to do this ?

    Thanks in advance
    [FieldName].BackColor = vbYellow ' or whatever color you want

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •