Continuous Form with an unbound control box???

[MikiH]

Hi All

I've got a form to list customers / suppliers, usual stuff company name, address etc.

Then I've got a subform which lists all project associated with each company.

On the subform there is an unbound combo box, to pick from a list projects and then update the other project details / controls on the subform.

My problem, when I change the company on the main form the combo box is empty (as its unbound) and when I try to update [me!combo] = [me!hidden project number] all the records change.

any ideas?

Thanks in advance

Mick

 

[SiJP]

When you change the combo dropdown (e.g. choose a selection), you have code that updates your record, right?

Well, by the sounds that same update code is running when you programatically set the value of that combo.

Are you using the After_Update event of the combo? If so, try changing to on_click?

------------------------
Hit any User to continue

 

[MikiH]

When I select a record it work no problem, as the unbound combo box updates / finds the record.

The problem is when I navigate through the companies on the main form. If i unhide the hidden project number its in there but the unbound has no data.

What I think it needs is some code to assign the combo boxes with the value of the hidden project number for each record on the continuous Form?

Thanks