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

Autofill

P: n/a
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?

Thanks...

Nick J

--

Kind Regards...

Customer Services Team
Blue Bell Trading

+++ WHEN REPLYING PLEASE DO NOT DELETE ANY OF THE TEXT AS WE NEED IT FOR
REFERENCE +++

Blue Bell Trading
Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Nick J wrote:
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?


-----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-----
Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.