Search results

ok thanks for your help bradcccs. its sorted now thanks to jfgambit as well

code i added was : Private Sub Form_Current() Dim rsNm As Variant rsNm = DLookup("[Video Title]", "Video", "[Video Number] =" & [Forms]![Copy_of_video]![Video Number]) Me.txtVideoTitle = rsNm it now works, but then when i click to add a new record it says that [video number] is missing from...

jfgambit: i tried this but when i tried to run the form it says that "i cant assign a value to this object"???? any ideas? thanks, Craig

thanks jfgambit, but i cant try it out at the moment because for some reason the builder will not open!!!!arghhhhhh again thanks for your help Craig

Hi everyone prolly a simple problem but could you help if possible: i have a form where when i choose a video number from a combo box, the next field, video title, is automatically populated by the choice from this combo box. This displays in the form but doesnt save to the video title field...