repeated entries in a column

[Karl Gardels]

I have some users that are trying to use a Form in
Access2000. They are wanting to know if, like in Excel,
when you enter data that is similiar or is the same, how
you can get it to repeat or pull up automatically? I
believe that they are entering data and would like
previous or similiar data to pop up so that they don't
have to type in as much. Is that possible in Access???

IF anybody has any answer to this question, please contact
me.

Thanks Karl Gardels
AIS Analyst
Hyatt Hotels

 

[Dave - Freedonia]

A combo box works just this way as long as you populate the combo box
with the information.

HTH,
Dave

 

[Hugh O'Neill]

I have some users that are trying to use a Form in
Access2000. They are wanting to know if, like in Excel,
when you enter data that is similiar or is the same, how
you can get it to repeat or pull up automatically? I
believe that they are entering data and would like
previous or similiar data to pop up so that they don't
have to type in as much. Is that possible in Access???

IF anybody has any answer to this question, please contact
me.

Thanks Karl Gardels
AIS Analyst
Hyatt Hotels

If you want the data you last entered in the same text box, to appear
automatically in the new record you are entering, then this 'standard'
three line code is what you need in the After Update event of the given
text box:

Private Sub txtName_AfterUpdate()

Me![txtName].DefaultValue = """" & Me![txtName].Value & """"

End Sub

where 'txtName' (in all three places) is the name of your text box to
which you want this to apply. There are four double quotes on either
side!

You will find that whatever you type in the text box, will be carried
forward to the next new record until you type in something different.
Then that gets carried forward and so on.

hth

Hugh