How can I use a Form button or tab into a field to browse a table & select

[garnf1]

I want to be able to compile a table of music titles with all their descriptor fields from a library of titles using a form.

I hope that for each record the user will be able to go and browse the whole library (even clicking out on hyperlinks in that table to research several titles) and when they're decided on one to return to the form and have the whole record pasted into their new table. They will be compiling a select presentation (show) of music titles & data.

Thanks

 

[Colin@Toyota]

It sounds like you want to use a subform... or maybe two; one displaying the entire music database, and one showing the selected records? I am not 100% sure about what you want it to accomplish though.

You mention a table of music titles, and associated descriptor fields... Something that sorts by maybe genre, then displays info in the following fields; Artist; Album Name; Song List; Record Label; Release Date; etc?

I hope that for each record the user will be able to go and browse the whole library

Do you mean for each selection they make, they can peruse the entire table of music data?

They will be compiling a select presentation (show) of music titles & data.

Is there a maximum size? Number of records?

I think there are a few ways to go about this, but maybe you could go into a little more detail about what exactly both you and your users want to be able to do... That way someone with more knowledge than me might be able to help