Auto fill record with macro

Discussion in 'Microsoft Access Macros' started by jrrock26, Jun 7, 2010.

  1. jrrock26

    jrrock26 Guest

    I have some information on a form that I would like to auto fill everytime I
    enter a part number. After the part number input I would then like a macro to
    fill in the part name and standard cost boxes based on that part number. I
    have a query that runs based off of a part number, to show standard cost and
    part name, no I just need them to auto fill on the form.
     
    jrrock26, Jun 7, 2010
    #1
    1. Advertisements

  2. jrrock26

    Jeff Boyce Guest

    It sounds like you've already decided "how" ... here are a few
    considerations...

    If your form is 'bound' to a table (or a query), what you're proposing might
    be making unnecessary duplicate values (more like a spreadsheet than a
    database).

    If you use a combobox to look up (valid) part numbers, you could have the
    form display the relevant fields that belong with the selected part number,
    rather than have to run your macro to insert values.

    Good luck!

    Regards

    Jeff Boyce
    Microsoft Access MVP

    --
    Disclaimer: This author may have received products and services mentioned
    in this post. Mention and/or description of a product or service herein
    does not constitute endorsement thereof.

    Any code or pseudocode included in this post is offered "as is", with no
    guarantee as to suitability.

    You can thank the FTC of the USA for making this disclaimer
    possible/necessary.

    "jrrock26" <> wrote in message
    news:...
    >I have some information on a form that I would like to auto fill everytime
    >I
    > enter a part number. After the part number input I would then like a macro
    > to
    > fill in the part name and standard cost boxes based on that part number. I
    > have a query that runs based off of a part number, to show standard cost
    > and
    > part name, no I just need them to auto fill on the form.
    >
    >
     
    Jeff Boyce, Jun 9, 2010
    #2
    1. Advertisements

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. cneeley

    Record auto fill

    cneeley, Jan 29, 2004, in forum: Microsoft Access Macros
    Replies:
    1
    Views:
    159
    Steve Schapel
    Jan 30, 2004
  2. Dave R.
    Replies:
    1
    Views:
    455
    Brendan Reynolds
    Jun 24, 2005
  3. Tom K via AccessMonster.com

    Find Record action to display a record that is the current record on another for

    Tom K via AccessMonster.com, Oct 31, 2005, in forum: Microsoft Access Macros
    Replies:
    0
    Views:
    757
    Tom K via AccessMonster.com
    Oct 31, 2005
  4. Guest

    Macro to auto fill fields

    Guest, Aug 3, 2007, in forum: Microsoft Access Macros
    Replies:
    3
    Views:
    730
  5. kks

    macro to auto copy and fill down data in column

    kks, Sep 15, 2008, in forum: Microsoft Access Macros
    Replies:
    1
    Views:
    1,994
    KARL DEWEY
    Sep 15, 2008
Loading...

Share This Page