Hi all,
Have a form with a subform. Main form has field [Title] and subform (only) has matching field [Title] and set to continuous forms.
The plan is, type in the name of a movie into the main form, so after each keystroke the subform [title] requeries/refreshes to display any matching entries in the underlying table [TblMovies] with the same characters.
For instance, typing into the main form field the characters "The" would link to titles aka 'The Hunt for Red October' or 'The Sum Of All Fears', and so on.
Not sure how to code this, can anyone help out please? I'm sure there's an easy way to do this, but I have been up for 18 hours now and have hit the wall...
Form is called [FrmAddMovie], and subform is called [FrmAddMovieSub]
thanks in anticipation
Pete