subform to change from combo with csv source

[Green Biro]

I have a form based on query of a linked csv. (The underlying data has to
remain as a csv as it is refreshed externally).

On my form I have a combo and a subform. I want my subform to change when I
change my combo value. Would have been easy if I could bind my combo but I
can't because it's a csv source. How can I link my child form to its
parent?

I'm guessing that I might have to pick up a change event (or something
similar) and alter the recordset but I don't want to go to VBA unless I
absolutely have to. and if someone has done this before and has some code
they could post, that would be especially helpful.

Thanks in anticipation.

GB

 

[John W. Vinson]

On my form I have a combo and a subform. I want my subform to change when I
change my combo value. Would have been easy if I could bind my combo but I
can't because it's a csv source. How can I link my child form to its
parent?

You can set the Master Link Field property of a Subform to the *name* of a
Combo Box on the form. That combo box need not be bound and need not be
updateable.

This isn't one of the options the wizard gives you, but you can just type it
in and it should work.
--

John W. Vinson [MVP]
Microsoft's replacements for these newsgroups:
http://social.msdn.microsoft.com/Forums/en-US/accessdev/
http://social.answers.microsoft.com/Forums/en-US/addbuz/
and see also http://www.utteraccess.com