Nick J wrote:[color=blue]
> Hi,
>
> I remember at one point access would autofill a text box when filtering by
> form, Like for example as I would type it would come up with matching
> records, similar to AutoComplete in Internet Explorer, I now have nearly
> 4,000 records, is this the reason why it does not perform this function
> anymore?[/color]
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
"Autofill" is a feature that only works when the user is entering data
into a recordset (form or datasheet/query) on the "Many" side of a One
to Many join between 2 tables. E.g. (the RecordSource of a Form or the
SQL of a query):
SELECT Many.ID, Many.ColA, One.ID, One.ColA, One.ColB
FROM One INNER JOIN Many ON One.ID = Many.ID
The user would enter valid data into Many.ID and the One.ID, One.ColA
and One.ColB would automatically be filled if there is a matching ID in
the One table. This is because there is only ONE record in the One
table that matches the Many.ID and Access graciously displays/fills that
data.
I don't believe that having a lot of records in the table cancels the
autofill action. Just make sure you have the query set up as described,
above.
--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)
-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv
iQA/AwUBQmPte4echKqOuFEgEQIJOQCgxhCRWmb90fWWVpCr3Jrqns E5tp4AoP+6
G1BbfAigNJHHIMG7K3fUi1Nw
=ofeX
-----END PGP SIGNATURE-----
