Search results

Thanks for help but I'm so sorry it still isn't working - I put in your suggested wording and now when I double click it says "enter parameter value - process" Is there a way to do this without using the macro? Thanks so much for helping :o

Tried this but it opened up the report with the surname "holland" no matter which surname I double-clicked. It also had no other data in the report - I'm beginning to think this is impossible. Thanks for sticking with it I really appreciate your help

have looked at it all ways but it is definitely called surname :(

Thanks for getting back to me - in the wherecondition of my macro there is nothing! If I put in [surname] = Me.surname it comes up with a box requesting me.surname Hope this makes sense

In design view of the form (in datasheet view) I have gone to properties (for surname) and where it says "on double click" I have entered a macro which opens the report

Thanks for your help but I don't think it is quite what I need - I want it to automatically open the report and populate it with whichever record I am double-clicking on. I don't want to have to specify the criteria in the command. Does this make sense? Thanks

sorry to be a pain Ken - that works but you have to manually type in the surname. I want it to automatically take the details from the double-click (if you follow me) so that you don't have to input anything just double-click and the record opens. Any ideas?

sorry it doesn't make sense - pretend I know nothing!

Help needed again please I have now changed the report so that it doesn't physically ask for the name and delivery date. I have managed to link the report to the form where you can double click on the surname and the report opens automatically BUT I want the report to only show the data from...

Help needed again please I have managed to link a report to a form where you can double click on the surname and the report opens automatically BUT I want the report to only show the data from the record that I have double clicked - at teh moment the report is coming up with thousands of pages...

Ken Thanks - I think I've found another way - by creating a macro so that when I double click on the name I can open the report. However I've now hit another snag which I think I need help on :rolleyes: The report which I want to open automatically asks for name and delivery date. This...

Ken Thanks for your help here - perhaps you can suggest another way around - I want to be able to see all the records in rows (like in datasheet view) but with a control button at the top linking to a report so you can click on the row you want then click the button to get the report for that...

okay - I think I've found the problem there but now I have another - I want to see the button at the top in datasheet view - is that possible? Thanks

Thanks but that doesn't change anything. The form header in design view is about 5 cm high with the headings across the top and the button underneath but when I go to normal view the form header is just 1 cm high with only the headings visible - I can't seem to make it any bigger in normal...

Help - I have created a control button in a form using the wizard and in design view it is at the top underneath all the headings (in the form header) but when I go to normal view it is not there. I have checked the properties and it is down as visible yes display always and transparent no. I...