By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,165 Members | 894 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,165 IT Pros & Developers. It's quick & easy.

Auto Fill

P: n/a
I have a query which lists Cat No, Vendor, Part No, Progressor. What I
would like to do is in a form which has been created when you select
the Cat Number, it automaticall yfills in the vendor, part and
progressor fields on the forms, so that it takes some of the data entry
out of the form, this when completed will be saved into the main table
for use on other forms and querys.

Any ideas of the best and easiest way to do this.

Dec 13 '06 #1
Share this Question
Share on Google+
2 Replies


P: n/a
"feeman" <fe*********@feehally128.karoo.co.ukwrote in message
news:11*********************@n67g2000cwd.googlegro ups.com...
>I have a query which lists Cat No, Vendor, Part No, Progressor. What I
would like to do is in a form which has been created when you select
the Cat Number, it automaticall yfills in the vendor, part and
progressor fields on the forms, so that it takes some of the data entry
out of the form, this when completed will be saved into the main table
for use on other forms and querys.

Any ideas of the best and easiest way to do this.
So these data elements are related? Well put them into a lookup table,
create a one-to-many relationship between your main table and the lookup and
include both tables in your form's query. That way you'll get Vendor, Part
No and Progressor for free when you enter Cat No. If you're not sure about
this then take a look at how it's done in the Northwind sample db that ships
with Access.

Keith.
www.keithwilby.com
Dec 13 '06 #2

P: n/a
Either pull them into the query behind the form, or use DLookup. I've
used both methods and noticed little difference in the response times,
and I'm using SQL Server backends with up to 500,000,000 records at
times.

feeman wrote:
I have a query which lists Cat No, Vendor, Part No, Progressor. What I
would like to do is in a form which has been created when you select
the Cat Number, it automaticall yfills in the vendor, part and
progressor fields on the forms, so that it takes some of the data entry
out of the form, this when completed will be saved into the main table
for use on other forms and querys.

Any ideas of the best and easiest way to do this.
Dec 14 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.