Results 1 to 6 of 6
  1. #1
    Join Date
    Aug 2004
    Posts
    4

    Smile Unanswered: I want to default a value in a text box in Query

    I have fields I have to validate and based on the value I want to default a certain value to the field

    If field A = 1, 2, & 3
    Set field b to "Good" (Column A & B are apart of the same table)

    Please help

  2. #2
    Join Date
    Apr 2004
    Location
    ny, ny
    Posts
    224
    is it OR or AND
    1 or 2 or 3

    OR
    1 and 2 and 3

  3. #3
    Join Date
    Aug 2004
    Posts
    4
    1 or 2 or 3

  4. #4
    Join Date
    Apr 2004
    Location
    ny, ny
    Posts
    224
    plz post more detail on wat u wanna do

  5. #5
    Join Date
    Jan 2004
    Location
    Toronto, Canada
    Posts
    259
    if i understand right,

    create a new update query,
    and pull that table into the query
    drop field b into the query

    in criteria: [TableName].[FieldA]=1 OR [TableName].[FieldA]=2 OR [TableName].[FieldA]=3

    in update to: "Good"

    that should do the trick

  6. #6
    Join Date
    Aug 2004
    Posts
    4
    Can I you the update query on the form at the field level for a combo box, go to properties , rowsource type Table/Query
    and when I select Row Source I can select the update query that I used

Posting Permissions

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