Fields In Forms

  • Thread starter Thread starter Paul Falla
  • Start date Start date
P

Paul Falla

Dear Crispy

This can be done one of 2 ways. Both rely on a unique
identifier for the album. The easiest way is to have a
notes field in the same table as the rest of the info
pertaining to the album. Alternatively you can have a
separate table for the album notes, but you must have an
identifier which is the same unique value as the
identifier for the album itself. You can then add a
subform to your main form to show the album notes.

Hope that this helps

Paul
 
They are notes that apply to the specific artist and therefore do not change
by atrist.

I tried the subform, which displays the correct data, but looks ugly, and
you cannot see all of the dtata when some of the notes are very long...
 
If you don't have space on your main form to view all the
data in the subform, perhaps you could use the tab control
where the main information from your form could be shown
on the first page and then you have a second tabbed page
to display the Artist notes held in the Sub form, this way
you can size the sub form to be much larger
 
Thanks - Neat idea - I will give it a try...


Paul Falla said:
If you don't have space on your main form to view all the
data in the subform, perhaps you could use the tab control
where the main information from your form could be shown
on the first page and then you have a second tabbed page
to display the Artist notes held in the Sub form, this way
you can size the sub form to be much larger
Click to expand...
 
Back
Top