Results 1 to 2 of 2
  1. #1
    New Lounger
    Join Date
    Feb 2003
    Griffith (Near Chicago), Indiana, USA
    Thanked 0 Times in 0 Posts

    Form Help (Access 2000)

    I have a form where I enter mailing info for my company (Freq. Form). I want access to automatically put in a contact name in this form so I can just print labels. (I'll have about 500 at a time, too many to do by hand!)

    I can get a contact name in there by using a default data but since many of my customers have multiple contacts it only puts in the first one (sorted abc). I want it to put in my primary contact which is defined by a checkbox.

    Do anybody have any suggestions on how I could do this?

    Can a query automatically update this value? Do I need to do it through code?

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Thanked 31 Times in 31 Posts

    Re: Form Help (Access 2000)

    If you have a Yes/No field that specifies the primary contact for a customer, you should be able to create a query that returns those primary contacts. Use the query as record source for the label report. If you want more specific help, you will need to tell us more about the table(s) you are using and their structure (fields and relationships, if relevant).

    What do you mean by "Can a query automatically update this value?" Which value should be updated, where, and to what?

Posting Permissions

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