Looking for a better solution

[mmchaley]

Hello all,

I have a form full of cascading unbound combo boxes which allows me to assign companies and people to a project.

I have a save button which writes the selected values to a table.

To view the assignments when the record is later viewed I have placed a bound field behind the combo box. This works, I am just wondering if this is a typical method or if there is a better solution.

Cheers,

Mark

 

[pr2-eugin]

Why would you need two forms that do the exact same thing? One to enter data and one to look at?

 

[mmchaley]

Because I cannot figure out how to get the current value from the table to appear in the unbound combo box on loading the form.

And I can't think of how to search for what I need so I can educate myself.

 

[pr2-eugin]

Okay you need only one BOUND Form. Through the button Click you can make the same form view details and add new records to it. To give you a very clear solution, I need to know what is the workflow. How many comboboxes? What are the field names?

 

[MarkK]

If I had a form that I would describe as being "full of cascading unbound combo boxes," then I might make that into a wizard, and have a separate form for viewing data.

Typical is tough to assess. Also, in my philosophy, there is always a better solution, but . . .

• can you imagine it?
• is it economical to implement?

 

[mmchaley]

I have 49 unbound combo boxes

Essentially each "heading combo box" is a combo box for company which is filtered by company type. Under that are the typical roles we need from that company type for proposals

i.e. Combo Box cboArchOrg is the combo box which returns all the companies in the database which perform architectural services. Under that are 3 combo boxes - cboArchDoR, cboArchPM, and cboArchPrincipal - these filter for that the specific architect firm selected in cboArchOrg and in the case of cboArchPM will return the people for that organization who are listed as Project Manager.

At the end of this form, I have a save button which writes the selections to tbl03ProjectTeam.

As I am moving through this, I am discovering multiple usability problems
1. when the form is reloaded all the combo boxes are at the default null value
2. If someone makes changes, all the combo boxes have to be reset
3. I can't see the selections which have been previously selected.

I just found the on form load event, so I will begin playing with that.

Thanks,

Mark

 

[mmchaley]

I have solved one of the issues

In the on Load of the subform I have used this code Me.cboGC = Me.GeneralContractor

In the after update of cboGC I have Me.GeneralContractor = Me.cboGC

This is getting the info in the form I need.

The current wall I am hitting is that when I change project records on the main form, the selections stay at the last entry selected from the combo box.

 

[mmchaley]

Solved it!

Need to learn what each event property actually does.