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 .

 

[Pat Hartman]

The combo's controlsource is the field it is bound to, ie the field where the selected value will be saved. I don't understand why you would want to change this on the fly or even if you can. Are you sure you are not trying to modify the rowsource. That is the query that controls what shows in the drop down list.

 

[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 ?

 

[Pat Hartman]

Sorry nebon, I have no idea where you are going with this. Do you know what binding is in this context and why would you want to change the column a control is bound to? Are you saying that you want to enter the name of a field in a text box and use that value to modify the combo's bound field? So if the user entered CustomerID, you want the combo to be bound to the CustomerID field rather than the StudentID field???????????