code problem

[nebon]

hallo guys, straight forward... I have the following problem :
Forms!FrmBooking!Combo0.ControlSource = Forms!FrmBooking!FILM_REF
Forms!FrmBooking!combo3.ControlSource = Forms!FrmBooking!SHOW_DATE

is this right to do in vb ?

 

[Mile-O]

No

The ControlSource would hold a field from a RecordSource or an expression.

It looks like you are wanting the value of a control on another form.

Forms!FrmBooking!Combo0 = Forms!FrmBooking!FILM_REF 
Forms!FrmBooking!combo3 = Forms!FrmBooking!SHOW_DATE

 

[nebon]

first of all , thanks for the replay ...
and , no no , thats not what I want .. I just want to make FILM_REF the controlsource for the combobox combo0
both fields are in the same form .

 

[nebon]

yes the rowsource controls what shows on the droplist.... but I also want the droplist to change according the record you are displaying/modifing ...
I mean, th rowsource only displays the data but I need to bound data to something so it can change in accordance to the record... and this is done through the conrolsource , right ?