I have not worked with Access in a few yrs. I hope i can explain my issue to make sense.
I am creating a database to keep track of Garbage bins we have on site. We have 24 bins. We keep track of 7 things for the bins. Location, Serial number, Size, If covered, product inside (cardboard, metal, garbage, wood), bin level, and when emptied. I set up a seperate table for each column so i could use a drop down and easily enter in more for each if needed. I then created a table linked to each of these with 144 columns (24 bins x 6 items tracked for each). I tried using the form wizard but it was too many columns. I used the wizard and created a form with 6 columns. I figured once i got this first row working properly i could easily copy/paste to make the rest work. In the end I am going to make it a 24x6 (spreadsheet kinda looking) form.
Under the bin level column i set up an option group as i only wanted the user to be able to select 1 of 4 options (this is not linked to any table). I set up a hidden textbox for the level as well. I set it up so when the user selects an option it populates the textbox which populates the table. My issue is when i select my option it selects the same option on the next record. Can this be stopped so it only selects the option for the current record?
I hope this makes sense. I tried to explain it as best as possible.
I am creating a database to keep track of Garbage bins we have on site. We have 24 bins. We keep track of 7 things for the bins. Location, Serial number, Size, If covered, product inside (cardboard, metal, garbage, wood), bin level, and when emptied. I set up a seperate table for each column so i could use a drop down and easily enter in more for each if needed. I then created a table linked to each of these with 144 columns (24 bins x 6 items tracked for each). I tried using the form wizard but it was too many columns. I used the wizard and created a form with 6 columns. I figured once i got this first row working properly i could easily copy/paste to make the rest work. In the end I am going to make it a 24x6 (spreadsheet kinda looking) form.
Under the bin level column i set up an option group as i only wanted the user to be able to select 1 of 4 options (this is not linked to any table). I set up a hidden textbox for the level as well. I set it up so when the user selects an option it populates the textbox which populates the table. My issue is when i select my option it selects the same option on the next record. Can this be stopped so it only selects the option for the current record?
I hope this makes sense. I tried to explain it as best as possible.
