470,604 Members | 2,022 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,604 developers. It's quick & easy.

autocomplete fields in my table

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
5 4429
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
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
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
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
"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.

Similar topics

40 posts views Thread by Alex | last post: by
2 posts views Thread by Michelle | last post: by
reply views Thread by venu | last post: by
5 posts views Thread by Andrus | last post: by
8 posts views Thread by nil | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.