Using Macros, can I, from Form 1, Copy field > Form 2, then paste field (into combo)?

[Rramjet]

Hi again...

Form 1 is used to create a new record, form 2 is used to display existing summary information associated with that record
drawn from a CLIENT table.



Using Macros I want to copy the ID from form 1 new record, close form 1, open form two, and paste the ID into the ID field (which, I have just realised - is in fact is a combo box - so it should automatically display the summary information for that client once the ID is pasted in....shouldn't it?)

Can this be done within the macro structure?

[Rramjet]

Okay - I can use SetValue and it can do the job if I select the right parameters - but it does not like pasting into the combo box and throws up an error (value cannot be set) and stops the Macro...

Well that's fine because I can use WarningOn = No to get rid of the error dialogue - but it still brings up the stopped macro dialogue ([Research_Id], [Research_Id]=[Research_Id]) is not good apparently... but it does precisely what I hoped it would do and this is the final macro step - so it will stop anyway... what can I do to force the macro to finish despite it thinking it has failed (when for my purposes it has definitely worked precisely as i need...)?

[Rramjet]

...Actually, I think this works BECAUSE the macro cannot complete. It pastes the ID value in, but does not "set" ID the value. This allows the combo to recognise the ID but not change the record (and so it does what it is meant to and displays the information associated with that ID). Amazing what can be done when you know nothing... I can live with the macro error dialogue (unless someone knows of a way to stop the macro a thtat point without seeing the dialogue - but when I tried it completed the macro and changed the record...) - so I guess I'll just tell the users to imagine it is a normal "Do you want to accept this..." type dialogue.