Results 1 to 3 of 3
  1. #1
    Join Date
    Aug 2002
    Posts
    3

    Unanswered: How do you update a query to a form instead of a datasheet?

    How do you update a query to a form instead of a datasheet?
    The query works OK on a onclick method but opens a datasheet view rather than going to the record in the form:
    To elaborate: I have a table with serial number as primary key and a autonumber for the ID field. Ideally if I enter a serial number in the form that is already in the database, it would pull up the record that contains that value in the serial number field.

    How do I make this happen. I'll admit I'm sort of a newbie.

  2. #2
    Join Date
    Aug 2002
    Posts
    78
    Jack. . .

    I hope I am no over simplifying your problem. If I understand your question correctly you would want to build the form off of the query as opposed to the table. The Form Wizard will help you.
    Just click new,
    Choose form Wizard
    in the drop down box choose your querey.

    FI I read your post incorrectly please forgive me. If I read it right this should help you.

  3. #3
    Join Date
    Aug 2002
    Posts
    3
    I'll give that a shot

Posting Permissions

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