Repeat previous entries like in Excel

  • Thread starter Thread starter Rick B
  • Start date Start date
R

Rick B

How do you have Access repeat an entry in a cell that was made in a previous
record. In other words, as I type, I want it to auto-fill if it finds a
match from a previous record, just like in Excel.

More details...

I have a table (tblCustomerContact), a form (frmMailings), and three fields
(MailSubject, MailFrntTemp, and MailBckTemp). There are other fields
involved, but they do not relate to this issue.


In the [MailSubject] field I will type something like...
"Initial postcard/Introduction"

In the [MailFrntTemp] field I will type something like...
"postF001"

In the [MailBckTemp] field I will type something like...
"postB005"

Let's say that I send this identical combination of postcard to ten people
in my database. Afer I update person one, and locate person two, I will tab
to the [MailSubject] field. as I make my entry, I want the field to
auto-fill. For example, after I type "I" it would fill in with the rest of
the text if that is the only [MailSubject] entry anywhere in my table that
starts with the letter "I".

Hope that is clear,

Rick B
 
I assume you are referring to any previous record, not just the nearest
previous record. You should be able to do this with combo boxes, filling the
row source of the combo box with unique entries from the field and setting
the combo boxes Auto Expand to Yes. This would also allow the user to pick
from the drop down list. You would need to requery the combo box whenever a
new entry was made to add it to the list.
 
Wayne:

That is just such an obvious answer! Thanks for the help!

Rick B

I assume you are referring to any previous record, not just the nearest
previous record. You should be able to do this with combo boxes, filling the
row source of the combo box with unique entries from the field and setting
the combo boxes Auto Expand to Yes. This would also allow the user to pick
from the drop down list. You would need to requery the combo box whenever a
new entry was made to add it to the list.
 
Rick B said:
How do you have Access repeat an entry in a cell that was made in a
previous record. In other words, as I type, I want it to auto-fill
if it finds a match from a previous record, just like in Excel.

More details...

I have a table (tblCustomerContact), a form (frmMailings), and three
fields (MailSubject, MailFrntTemp, and MailBckTemp). There are other
fields involved, but they do not relate to this issue.


In the [MailSubject] field I will type something like...
"Initial postcard/Introduction"

In the [MailFrntTemp] field I will type something like...
"postF001"

In the [MailBckTemp] field I will type something like...
"postB005"

Let's say that I send this identical combination of postcard to ten
people in my database. Afer I update person one, and locate person
two, I will tab to the [MailSubject] field. as I make my entry, I
want the field to auto-fill. For example, after I type "I" it would
fill in with the rest of the text if that is the only [MailSubject]
entry anywhere in my table that starts with the letter "I".

Hope that is clear,

Rick B
Click to expand...

Incidentally, it's possible to make a text box behave this way, but the
code is slightly elaborate. If combo boxes will do it for you, that's
the best way. You can cover up the drop-down arrows with labels or
boxes set to the form's background color, if you want.
 
Back
Top