linking combo box from main form to sub form. help please :(

[ladyfame]

heya, can someone please help me?

right, so i have a form which i made. and there is a sub form.

i have created a drop down list with - 0% 5% 10% 15% and 20%, on the mainform
i added a new column to the sub form and put =[combo42] because this is what the combo box was called
but it says #name?

HELP HELP HELP !!!!!!!
i need the value to appear in the sub form table when i select it from the drop down list

so i like need to know how to link a combobox from the main form to the subform so whatever you select appears there.
thanksssssssssssssss.

 

[KenHigg]

Here's a stab in the dark:

=forms!myFormName![combo42]

 

[ladyfame]

Here's a stab in the dark:

=forms!myFormName![combo42]

thanks for trying to help, it didnt work

 

[KenHigg]

Did you change 'myFormName' with the actual name of your form?

 

[ladyfame]

Did you change 'myFormName' with the actual name of your form?

ooooo, lol - nope! I'll try that now!

 

[ladyfame]

OMG THANK YOU SO MUCH Its work yay
this is now appearing in all of rows of this column, do you know how to do it so it only appearing in the ones which have a tick box in another column?