I'm a FileMaker newbie with Access experience. I'm trying to set up a reporting menu where the user can specify the criteria to filter records by and some other data to use on the report. On the main data layout, there is a portal and that is one of the fields by which records can be selected for reporting. Using a script, I have managed to get into Find mode and insert some data from the reporting layout into the field on the main data layout BUT it is the field name from the reporting layout, rather than the contents of that field. What's the magic characters I have to add, please?

Found the answer at last! Using the script steps Copy and Paste, rather than Set Field. :

Hi Brian

Using the copy and paste will remove any prior content of the users clipboard and is therefore avoided wherever possible. The set field script step is much more suitable.

I couldn't quite follow what your post said but I do know the following

Set Field [target field; "Source field"]

will put the words Source field into your target field whereas this

Set Field [Target field; Source field]

will put the contents of the field called source field into the target field

HTH

Phil

Phil,

Thank you for your reply - I understand the implications of using the Copy script step but can live with that for the moment (so can the user). I believe I used the Set Field script step early on but will have another look at it.

Thanks,

Brian