Subform_automatically add new row with value

[THANOS]

Hi ! I need once more your kind assistance to the following issue.

I have a continuus subform with 2 comboboxes, one is: cboPhases and the other: cboStatus.

The first combo takes values from a table named "Phases" and holds one column with the 9 phases of a project: phase 1_Review, phase 2_Commects, etc.
What I do till now is to open a new line at each change and select a phase and change the other combo to "pending" or "complete" depending of the project status. I was wondering if it is possible to do the following:
When I select the "phase 1_Review" and status "pending" then a new line to be opened taking automatically the value of the next phase "phase 2_Comments" and this should be remain inactive (grey) until I select "completed" in the first phase. Is this possible?

Thanks in advance for your attention.

 

[ajetrumpet]

yes it's possible. But honestly, in my opinion, more explanation or a sample would be needed to get you an answer quickly.

 

[THANOS]

Thanks for your interest.

I attach a sample of my database. I'll try to explain a bit more what I want to do. As you can see when you select a project you may see the phases that had run. Each phase starts only after the previous had been finished. And then I check with "Complete" and I add the next phase. Phases are always in the same sequence : 1, 2, 3, 4 ... 9. As I said in my previous post what I want is : each time I open a phase Instead of a "blank new line" the next phase to be automatically added and appear innactive until I check the first complete. Then phase 2 becomes active and phase 3 added appear as innactive and so on up to phase 9.

Is this something that can be done ?

Thanks again.

 

[ajetrumpet]

i think the best thing to do is ask a question one at a time here, because i don't really have time (maybe someone else does) to go through your DB and search for what is causing what. So, to answer...YES, it is possible. I would first start with the sequential numbering that you have going on between all of the phase records (that being the 7th character in each records value - the NUMBER of the phase). You can use the MID() function to check the records in the form for the last record's "number" within the phase value. How you do that, I'm not sure because I didn't check recordsources very closely of the forms you have to deal with.

I did notice though...that the sources are SQL statements and not tables. It would probably be easier with tables as the bound objects. Like I said though, this is obviously doable, but it would take some time to sift through for me...

 

[THANOS]

respect. In fact I didn't realize that my question was that complicated. I guess I will have to procceed without this solution unless someone may be so kind to assist.

thanks anyway.