Search results

Absoloute legend missinglinq, worked a treat!!! :) Thanks for everyones help!

Thanks, ive set up a query now. However, the query only matches the records if there is a record in place in the related table/form. I am trying to add data into this table/form so when I click on my new button in the first form (opens query/form) if there is no related record (which will be...

surely there is a way of doing this? :(

No, they are based on differeent tables.

Hi thanks for your quick reply. Ive created the button again: Form operations - open form - (my form) - open the form to find specific data to display - (matched visitID) However when opening the form, it still opens at record number 1 every time :confused:

Hey I have two forms, both of related tables. Both related by VisitID field. So when I input data into the first form I then want to input data into the related table/form, so ive created a command button which opens the other form. However it always opens the form on record number 1. I want...

Cheers, I have added a simple open form command button. One very Annoying thing though, when you click on the open form button, it opens the FrmWrkDetials on a random record. You then have to edit the VisitID number to match the primary key in FrmVisitDetials. Is there away of opening the form...

adding record to related table using form - access noob. Hi there, apologies if this question is a bit basic, I have searched for the answer to this question, and im sure it must be out there but i've had no luck after searching for quite a while. How do you add data to a related table using...