Results 1 to 2 of 2

Thread: Restrict rows in MS Access form

  1. #1
    Join Date
    Aug 2003
    Posts
    1

    Unhappy Restrict rows in MS Access form

    I have a table WorkExperience. I want to restrict no. of work experience for each applicant to 3 only. How can I do it?

    I am using a MS Access form with datasheet view.

    I am in soup guys, fasssst plz....

  2. #2
    Join Date
    Jan 2003
    Location
    UK
    Posts
    277
    You mean you only want them to enter a max of 3 work experiences.

    Can you not have a variable that you just add to on the afterupdate and/or current event of your form. When it reaches 3 you can change the allow additions property to 'No'

Posting Permissions

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