Unanswered: Entry form needs popup box to obtain more info..
I need to add something to a data entry form to obtain additional information. My current form populates a products table. The form will populate multiple product records from this form with one add button.
Example, I sell products logoed for many teams, so I have a vendor who makes a Birdhouse for several collegiate teams. So instead of re-entering the same info multiple times, it loops through based on the teams selected in a multi list. While most information is static for every product type, one piece of information isn't like the manufacturer's product code. Let's say for the birdhouse it is BH-ALA for Alabama, BH-AUB for Auburn and so on. Each different type of product from different manufacturers will have a different product code or SKU #. What I thought I would do would pop up a message type box letting me know which team we are dealing with with a window for me to enter the product ID and then hit enter and update the row with appropriate information from the form entry as well as the product code pop-up. Below is the code from my form currently..
Dim dbsProducts As DAO.Database
Dim a As Long
Dim nbr As Long
Dim fname As String
Dim rstProduct As DAO.Recordset
Dim rstTeams As DAO.Recordset
Set dbsProducts = CurrentDb
Set rstProduct = dbsProducts.OpenRecordset("tblProducts", dbOpenTable)
I need to have some kind of message box that gets my user input of the manufacturers item number and use this value to populate a field as well as be concatenated to another field. Currently all fields right now on the form are the same for each loop through. Example, Product Name is Birdhouse, that field is birdhouse for every team I choose in the team list. Unit Price, is the same for each birdhouse as it loops through for each team. The MFG # is the only field that is unique or could have a different value for each team.
I'm not sure how to get this unique value inserted properly on each row. I know how to place a MSG box, but I don't know what to use to get user entry to obtain this value. Is there something like a MSG box that acquires user entry?
An alternative approach would be to populate a combobox with the list of teams in a list box, slect the required team(s) from the list box for a specified product type
then press a button to writee your records to the table.
you can iterate through the list box selected collection to find which teams have been selected.
You can evolve ythe design to have 2 list boxes one teams available and one selected. (similar to the forms & report wizard column field selectors)
this depends on whether you can make a commone coding policy