Saving records after last line is entered plus some

[wideasleep]

Hi Everyone,

I have a design issue here (go figure) on a form and kind of need some opinions on how to do this. I have my ideas but need a 2nd, 3rd, 4th.......opinions.

1st I will have a combo box with Formulas for Chemicals our company makes. I'd like to be able to have only the next formula in line of the schedule to be the only one to be selected but the others grayed out. Once the next selection is made in this combo box it will populate additional fields in this table

2nd once that is selected there will be another table that will be populated with combo boxes from the 1st combo box. I was planning on using cascading combo boxes for this. In this table the 2 combo boxes will be [Stage] and [Product Code]. Each stage has a multiple products for that stage. So this is looking like cascading boxes on top of each other (unless someone can recommend anything else).

Ok once all this process is complete we have to select the next product in line and have to save all the records from the previous formula which is the big question I have. We have to be able to use this as a history to compare with others that are made for trouble shooting issues. This part is really racking my brain.

I'm running Access 2007 on Windows Vista.

Your input is very much appreciated!

[MMcCarthy]

I'm sorry but I don't really understand the question you are asking. I know you have given a lot of information but I can't picture the form as you describe it.

Try forgetting about the layout of the form and just describe the logic of what you are trying to do.

Mary

[wideasleep]

Mary,

Sorry, this is a bit difficult to explain for me. I work in a chemical plant where everything in terms of technology are done backwards. I'm trying to keep a similar layout of our current form for ease of use for our employees.

OK let me try this again.

I have a combo box [PRODUCT CODE] that needs to have only one item selectable in it, based on a order of scheduled items.

Once the item in the 1st combo box is selected it needs to populate another combo box [STAGE]. The selection in the 2nd combo box will then populate a 3rd [code].

OK, now for the final issue. After the recording of all the information there will be a checkbox that will make the next item in line selectable in the 1st combo box [PRODUCT CODE]. Once the next item is selected it needs to save all the records from the previous item while creating a new set of records.

Hope that helps

[MMcCarthy]

Mary,

Sorry, this is a bit difficult to explain for me. I work in a chemical plant where everything in terms of technology are done backwards. I'm trying to keep a similar layout of our current form for ease of use for our employees.

OK let me try this again.

I have a combo box [PRODUCT CODE] that needs to have only one item selectable in it, based on a order of scheduled items.

Once the item in the 1st combo box is selected it needs to populate another combo box [STAGE]. The selection in the 2nd combo box will then populate a 3rd [code].

This part is easy
Have a look at this tutorial

Cascading Combo boxes

OK, now for the final issue. After the recording of all the information there will be a checkbox that will make the next item in line selectable in the 1st combo box [PRODUCT CODE]. Once the next item is selected it needs to save all the records from the previous item while creating a new set of records.

You can't do this. You can't change the selected item and still retrieve the previously selected item unless you've recorded the value somewhere.

You say save all the records from the previous item but you don't explain what these records are or where they are being saved.

[wideasleep]

Mary,

Each selection in the combo box [PRODUCT CODE] will be for a set of records for each proccess that we do. Once the process is complete the records will be used for reference. I guess i'll have to just make a new table for each item in the [PRODUCT CODE] combo box.

I appreciate your efforts to help me with this. I was already looking at the tutorial Rabbit has and I thought I might have found a error in the tutorial unless I'm that new that I don't understand it. Where he references the OnChange Event is what is throwing me. The code indicates AfterUpdate unless I'm just not understanding it.

Curt

[MMcCarthy]

Mary,

Each selection in the combo box [PRODUCT CODE] will be for a set of records for each proccess that we do. Once the process is complete the records will be used for reference. I guess i'll have to just make a new table for each item in the [PRODUCT CODE] combo box.

I appreciate your efforts to help me with this. I was already looking at the tutorial Rabbit has and I thought I might have found a error in the tutorial unless I'm that new that I don't understand it. Where he references the OnChange Event is what is throwing me. The code indicates AfterUpdate unless I'm just not understanding it.

Curt

I'll have a look at that. You are right it should be the After Update event.

Have a look at this tutorial for some advice on the way your tables should be structured.

Database Normalisation