Search results

Hi Thanks for your reply. The reason I am looking at doing it, was a short cut to go back to the record to carry out any changes. I have a list of projects, and I click on the button to open the report. When looking at the report, I would like to click on the project ID to go back to the form...

Hi I have a report that all works fine, created from a query. The report is opened from a button on the main form. What I am after, is that when I double click on the ID in the report, it closes the report and then goes to the record in the form I have just double clicked on. So, if the...

That's great, all sorted using both you guys help!!! Thank you very much! Foster.

I have just seen the link, on the link you sent me, apologies, will look at that..

Hi Paul Thanks for the reply. That seems to show the records that match the info in both forms, but I am after the button to open the second form, with the [Reference] field already filed in. Basically, the second form is a diary form, so will have multiple entries for each [Reference] field...

Hi I am sure this is straightforward, just been going around in circles trying to figure this out. I have a main form, with the main field being [REFERENCE], with this field being unique. I just want a button on the main form to open a second form, that has the same field [REFERENCE], which...

That's great guys, thank you very much, problem sorted!! Foster

Hi Many thanks for the replies. I have just looked at the split form (didn't know you could do that to be honest) and that does the job, but as mentioned it does show all the fields which is too many, so I will look at the ESF method when I get a chance. Thanks again! Foster

Hi I have a simple form, with a sub form in it. All info is based on the same table, but the main form is for adding new records, and editing existing records etc. The Sub form is in datasheet view and just lists all the records with specific fields and is not for editing purposes. I am after...