repeated entries in a column

  • Thread starter Thread starter Karl Gardels
  • Start date Start date
K

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
 
A combo box works just this way as long as you populate the combo box
with the information.

HTH,
Dave
 
Karl said:
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
Click to expand...


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
 
Back
Top