If your field is named "StoreID", the implication is that this is a unique
(store) identifier.

We're not familiar enough with your situation (until you tell us more) to
know why you'd want to have more than one record with the same StoreID in
it. A bit of context can help us offer more relevant suggestions.

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or psuedocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.

"Helpdesk" wrote in message
...
I would like to know how to get a text box to populate the field from the
previous text box. Example: I have a text box call Store ID so the first
record I put in a Store ID number and I would like the next record to
automatically populate with the information that is in the first Store ID
box.