If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Text Box populate
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. |
#2
|
|||
|
|||
Text Box populate
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. |
#3
|
|||
|
|||
Text Box populate
Here is the situation: This access program will be used to do inventory at a
store. I have 4 fields: 1. Store ID 2. Location ID 3. UPC Code 4. Quantity so when a person starts the inventory they need to enter in a Store ID and a Location ID (the store is broken down into locations). Then they scan the item and type in the quantity. Instead of them having to constantly type in the Store ID and Location ID, these fields should automatically populate but have the ability to change the Location ID. Hopefully this helps in explaining the situation better. "Jeff Boyce" wrote in message ... 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. |
#4
|
|||
|
|||
Text Box populate
I suspect your data structure would benefit from further normalization.
Based on how I understand your description, one store can have many locations, and one location can have many UPC Codes (items). In a well-normalized relational database, this would require three tables, not one. The first table would hold StoreID and any other fields related ONLY to the store (e.g., address, etc.). The second table would hold LocationID, and any other fields related ONLY to the location (e.g., Location Short Name, Description, ...) The third table would hold UPC Codes, and any other ... But this is just a start! Your inventory record would consist of the fields you described, plus probably an InventoryID field, and a date/time field to record WHEN that store in that location had that many of that item. And we're still not done. Rather than repeatedly storing the same StoreID (by default or by data entry), you would benefit from using a mainform/subform construction. The main form would have Store and Location fields, while the subform would be based on that junction table. By setting the subform to use the mainform's (i.e, the 'parent's) StoreID and LocationID, you NEVER have to re-enter the StoreID or the LocationID for multiple items (UPC Code) from the same Store/Location. Each time you move to a new location (and/or store), enter those once in the main form and let Access handle entering them into the appropriate subform controls. Good luck! 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 ... Here is the situation: This access program will be used to do inventory at a store. I have 4 fields: 1. Store ID 2. Location ID 3. UPC Code 4. Quantity so when a person starts the inventory they need to enter in a Store ID and a Location ID (the store is broken down into locations). Then they scan the item and type in the quantity. Instead of them having to constantly type in the Store ID and Location ID, these fields should automatically populate but have the ability to change the Location ID. Hopefully this helps in explaining the situation better. "Jeff Boyce" wrote in message ... 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. |
Thread Tools | |
Display Modes | |
|
|