Auto fill record with macro



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

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

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

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!


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

Ask a Question

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

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question