advice for tabs & 1-many tables

[mleczko]

Hi,

Just need a bit of advice as to which way is the best to go.

I've got a form that has tabs on it, when I flick to a tab I want to
display/edit/delete a subset of records from another table. The table
for the form has a 1-many relationship with the records I'll be
displaying in the tab control

Now, what is the easiest way to go? I don't know about subforms, they
seem weak, display recrds in excel format. I've made up a dynamic
query to select the neccessary records to process. This will work but
I'll be populating every field programatically, there's got to be an
easier way to do this

Thanks in advance
Nick

 

[mleczko]

Got it, installed the subform wizard and it works like a charm. Does
exactly what it's supposed to do. me suprised ;-)

N

 

[John Vinson]

I don't know about subforms, they
seem weak, display recrds in excel format.

They're very powerful, and display the records in any way you choose:
single form, continuous form, or the (default) datasheet form, take
your pick.

John W. Vinson[MVP]