autocomplete fields in my table

[Michelle]

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

[Michael Juul Hansen \(remove NOSPAM to reply\)]

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

[Michael Juul Hansen \(remove NOSPAM to reply\)]

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

[Lumpierbritches]

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

[Lumpierbritches]

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

[Michelle]

"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