Updating a combobox in subform

[Vallan]

Hello.

I have trouble with updating a combobox in a subform.

I hace combined 3 columns into one in a table.

Like this.......... Help:[1]&[2]&[3]

I have a form with a subform where this ciombobox are.

If i want to make a new "Help" i open Changeform.

The problem is when a close this form and go back to the other form i have done a macro wich updates controls in the form and subforms.

All updates works accept the "help" combobox.

Can anybody tell me why?

Could it depend on that its a primary key? (It shouldnt.)


Sorry if my english is crap.


Matt

 

[ajetrumpet]

All updates works accept the "help" combobox.

Can anybody tell me why?

Could it depend on that its a primary key? (It shouldnt.)

It's hard to tell without a picture, or the code behind the Macro Matt. Your question was very general, and it's like shooting in the dark trying to answer this right now. How about a picture (at least)?

 

[Vallan]

file

Here is maybe a better explanation.

At least i hope so.

 

[ajetrumpet]

Vallan,

I apologize for this, but can you post the RowSource of the combo, and the code behind the macro?

 

[Vallan]

Hi.

This is the Rowsource that goes to the combobox.

The first is the row of ID.

Virkeskod: Inkommande_träslag_TBL!Träslagskod_ink & Inkommande_tjocklek_TBL!Tjocklekkod_ink & Inkommande_bredd_TBL!Breddkod_ink & Inkommande_kvalite_utförande_TBL!Kvalitekod_utförande_ink

The macro is the simple way in the macro where you can use the shortcuts.

First line is Test_macro Close change_FRM
Updatecontrol Subform!Virke_ink

Matt