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

autocomplete fields in my table

P: n/a
Hello, I have been banging my head against my computer trying to
figure out how to have access autocomplete some fields in my table,
using data from another table.

I have simplified my question with pictures, so please read my
question here:

http://www.financialsolutionalberta.com/accessquestion/
Thank you very much in advance for any of your help, I will be
checking this thread every 2 minutes lol.

-Michelle
Nov 12 '05 #1
Share this Question
Share on Google+
5 Replies


P: n/a
You use a query

Instead you might consider adding a field to the Clients table, e.g. Status
(possible client or an active) simply to avoid redundancy.

HTH
"Michelle" <hi*******@msn.com> skrev i en meddelelse
news:96**************************@posting.google.c om...
Hello, I have been banging my head against my computer trying to
figure out how to have access autocomplete some fields in my table,
using data from another table.

I have simplified my question with pictures, so please read my
question here:

http://www.financialsolutionalberta.com/accessquestion/
Thank you very much in advance for any of your help, I will be
checking this thread every 2 minutes lol.

-Michelle

Nov 12 '05 #2

P: n/a
In the online help use the keyword AutoLookup

HTH

"Michelle" <hi*******@msn.com> skrev i en meddelelse
news:96**************************@posting.google.c om...
Hello, I have been banging my head against my computer trying to
figure out how to have access autocomplete some fields in my table,
using data from another table.

I have simplified my question with pictures, so please read my
question here:

http://www.financialsolutionalberta.com/accessquestion/
Thank you very much in advance for any of your help, I will be
checking this thread every 2 minutes lol.

-Michelle

Nov 12 '05 #3

P: n/a
Why don't you instead of having two tables, use a checkbox Null being not a
client or just a prospect and checked being a client, then use a query to pull
your data for either or. Using a query would be the best way to also autofill
or use the after update from a combobox to populate fields based on a combobox
query.

combobox.column(0) would be your first field, combobox.column(1) would be the
second field etc etc.

HTH
Michael
Nov 12 '05 #4

P: n/a
Why don't you instead of having two tables, use a checkbox Null being not a
client or just a prospect and checked being a client, then use a query to pull
your data for either or. Using a query would be the best way to also autofill
or use the after update from a combobox to populate fields based on a combobox
query.

combobox.column(0) would be your first field, combobox.column(1) would be the
second field etc etc.

HTH
Michael
Nov 12 '05 #5

P: n/a
"Michael Juul Hansen \(remove NOSPAM to reply\)" <NO******************@mobilixnet.dk> wrote in message news:<c6***********@news.orange.dk>...
You use a query

Instead you might consider adding a field to the Clients table, e.g. Status
(possible client or an active) simply to avoid redundancy.

HTH

Okay I have fooled around with the query feature in access, but still
have not figured out how to achieve auto-filling the fields i want
using query...anyone care to explain a bit more in depth in how i do
this? Thank you

-Michelle
Nov 12 '05 #6

This discussion thread is closed

Replies have been disabled for this discussion.