Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2005
    Posts
    240

    Unanswered: Prevent New Record until form is filled

    Hi folks,

    What is the best method of preventing a record being created, until certain fields/controls are filled?

    Thanks

  2. #2
    Join Date
    Nov 2004
    Location
    Harrogate, N.Yorks, UK
    Posts
    83
    Set the Required property on the fields to 'yes' in your table design.

  3. #3
    Join Date
    Sep 2005
    Posts
    240
    OK, that will work for the time being as I'm currently creating an update for one of my databases natively in Access. But is this property available in SQL Server when I make it live?

    If not, is there anything I can do in VBA for this?

Posting Permissions

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