J
James
Hi I would like the answers to a couple of questions in my
database... I hope someone could please assist...
I have created an input form (with help from an MVP) with
a main form and a sub form.... How do I get a cmd button
to clear both the main form and the subform so I can add
another record?
Again through the same MVP has helped my rationalise my
tables and everything but the one thing I now need to do
it correctly refrence everything from one table into
another... I have two tables one is called tblMP3Title (It
has a list of CD titles) and one called tblMP3List
(Containes all the foders on the CD) I have a one - to -
many relationship with them so that I have one title to
many folders... How can I copy the titles from the
tblMP3List to tblMP3Title and get them correctly refrenced?
I have on my MP3 form some next and previous butons which
scroll through the records in tblMP3List... so there going
down the list of the title and the folder name... I would
like it to go through the Titles. So I would need it to
change the title at the top rather than keep pointing out
the next record in tblMP3List... Could I just swop over
the next and previous buttons to look at a diffrent table?
If so how do I do this?
Many Thanks for you time and effort...
James
database... I hope someone could please assist...
I have created an input form (with help from an MVP) with
a main form and a sub form.... How do I get a cmd button
to clear both the main form and the subform so I can add
another record?
Again through the same MVP has helped my rationalise my
tables and everything but the one thing I now need to do
it correctly refrence everything from one table into
another... I have two tables one is called tblMP3Title (It
has a list of CD titles) and one called tblMP3List
(Containes all the foders on the CD) I have a one - to -
many relationship with them so that I have one title to
many folders... How can I copy the titles from the
tblMP3List to tblMP3Title and get them correctly refrenced?
I have on my MP3 form some next and previous butons which
scroll through the records in tblMP3List... so there going
down the list of the title and the folder name... I would
like it to go through the Titles. So I would need it to
change the title at the top rather than keep pointing out
the next record in tblMP3List... Could I just swop over
the next and previous buttons to look at a diffrent table?
If so how do I do this?
Many Thanks for you time and effort...
James