i will try first thing in the morning it's 1am here in China !!! must go to bed - many thanks for your help I hope your advice will help me get it sorted
Many thanks - Gibby
when i am in the form and adding contacts i can move backwards and forwards
however when i close the form then open it again that's when the fun starts
i see a blank form and no other entries
all the previous entries are in the table nice and safe
any the wiser !!!???
Thanks - Gibby
SELECT Contacts.*, Months.* FROM Contacts INNER JOIN Months ON Contacts.ContactID=Months.ContactID;
Is this what you wanted?
Everything else is OK
I have to say sorry now - alot of what you have said went straight over my head I am very new to this !!!
Many thanks - Gibby
Hiya
Please be gentle I am no expert at this sort off thing.....
Is there a way of clicking on a line in a table and the relavant form opens in a new window. You can then edit the form and the table is updated.
Thanks
Gibby
Thank you but no joy
Hiya
I have tried everything but still the same
I input data into the form click forward to complete another form. All the data goes into the tables fine, however when I go back into the form I can't view any of the completed forms....it's just a blank form no record of...
Hi
Two things..
First - I have a db (access) and I have created a form (simple contact form). However when I input data then exit the form, when I go back into the form I can't view all the other forms I have completed. All the data is safely in the tables but I can't view it in the form...