How do I get the text to pop up or repeat in Access Forms/Table S.

[Guest]

I created a new database for paying PO's. I know access has a way that if
you are typing in addresses or words in fields, it remembers it and it pops
up for you. It is not doing this in my database table or form. I can not
get the answer anywhere on how to do this. I operate in XP, and have Access
2002. Can anyone help me?

 

[Tom Wickerath]

Bkellie,

You can use a keyboard shortcut, as shown in this article:
http://office.microsoft.com/en-us/assistance/HA010546551033.aspx

Insert the data from the same field in the previous record: CTRL+'

Alternatively, you can define which fields you want to be automatically populated with the
contents of the previous record by using a VBA procedure, as outlined in the following KB
article:

How to fill record with data from previous record automatically in Access 2000
http://support.microsoft.com/?id=210236
Note: Although this article indicates "Access 2000" in the title, it should work equally well in
Access 2002 or 2003.

There is no need to post the same question 2 times in a four minute window. Please be patient
instead.
(

Tom
___________________________________


I created a new database for paying PO's. I know access has a way that if
you are typing in addresses or words in fields, it remembers it and it pops
up for you. It is not doing this in my database table or form. I can not
get the answer anywhere on how to do this. I operate in XP, and have Access
2002. Can anyone help me?

 

[Tom Wickerath]

Bkellie,

You can use a keyboard shortcut, as shown in this article:
http://office.microsoft.com/en-us/assistance/HA010546551033.aspx

Insert the data from the same field in the previous record: CTRL+'

Alternatively, you can define which fields you want to be automatically populated with the
contents of the previous record by using a VBA procedure, as outlined in the following KB
article:

How to fill record with data from previous record automatically in Access 2000
http://support.microsoft.com/?id=210236
Note: Although this article indicates "Access 2000" in the title, it should work equally well in
Access 2002 or 2003.

There is no need to post the same question 2 times in a four minute window. Please be patient
instead.
(

Tom
___________________________________


I created a new database for paying PO's. I know access has a way that if
you are typing in addresses or words in fields, it remembers it and it pops
up for you. It is not doing this in my database table or form. I can not
get the answer anywhere on how to do this. I operate in XP, and have Access
2002. Can anyone help me?

 

[Guest]

auto fill is possible only with combo boxes. convert text box to combo box
and set its Auto Fill property to 'Yes'
rgds
(e-mail address removed)

 

[Guest]

Dear Sheju,
I am in need of this funtion as well. When I change my text box to a combo
box
the combo box wizard gives me three choices
1. I want the combo box to look up the values in a table/query
2. I will type in the values that I want
3. Find a record on my form based on the value I selected in my combo box
Which of these 3 selections should I choose?
Also, looking in the "property tab" for a combo box, I do not see the "Auto
Fill" property which you indicated earlier should be changed to "YES". I am
so lost, this is my first database I am attempting to build. Any information
and/or direction you can give me will be appreciated.
Thanks !!