Hi all.
I have a problem which I hope I can get some help..
I have a ComboBox which select a value from a huge list (up to 250 - 300 records). When a value are selected, a releated subform updates. Just like a Invoice system. The CombBox have two coumns; (0)= ID number, and (1)= ID Text.
When dobbelclick on ComboBox, a separate forms opens, and this form have a TextBox and a ListBox. When entering text in TextBox "narrow down" the ListBox with fewer lines. When dobbelcick on ListBox, the ListBox.Value are copied to CombBox.Value, and the the separate form closes.
The problem are automatic update the subforma based on the new value in ComboBox. The command Forms![Navigationform]![NavigationSubform].Form![ReleatedForm].Requery dont work, and the same command with .refresh generates an error stating I can't use ths method on this component (or something like that).
Any suggestion on where to look for a solution?
Regards..
I have a problem which I hope I can get some help..
I have a ComboBox which select a value from a huge list (up to 250 - 300 records). When a value are selected, a releated subform updates. Just like a Invoice system. The CombBox have two coumns; (0)= ID number, and (1)= ID Text.
When dobbelclick on ComboBox, a separate forms opens, and this form have a TextBox and a ListBox. When entering text in TextBox "narrow down" the ListBox with fewer lines. When dobbelcick on ListBox, the ListBox.Value are copied to CombBox.Value, and the the separate form closes.
The problem are automatic update the subforma based on the new value in ComboBox. The command Forms![Navigationform]![NavigationSubform].Form![ReleatedForm].Requery dont work, and the same command with .refresh generates an error stating I can't use ths method on this component (or something like that).
Any suggestion on where to look for a solution?
Regards..
