Auto Fill

[feeman]

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.

[Keith Wilby]

Re: Auto Fill

"feeman" <feehally128@fe ehally128.karoo .co.ukwrote in message
news:1166019428 .447368.84000@n 67g2000cwd.goog legroups.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.

https://www.keithwilby.com

[ManningFan]

Re: Auto Fill

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.