Set Value Macro in a form

[john151]

Hi everybody!

I have got a small question about the "set value" macro.
I am trying to use this macro in a form, so that the user doesnt have to type or lookup that value.

So what I want is a macro, that copies a value from a controlfield of a form and inserts this into another form and new record.

What i have is a inventory list of books. Some writers have written more than one book, so I created forms for <Add new book to existing writer>. But until now it doesnt work. Maybe somebody has a better idea.

Thanx for the help!

john

 

[maxmangion]

instead of using the set value action of macro, search this forum for OpenArgs, it is a better recommended way of passing your value.

 

[john151]

sure but...

when I use OpenArgs I am not able to input new data. i can just move to a record and not add information to a client.

what should I use to add a book to an existing writer? This two tables: Writer and books are related to each other in a one-to-many relationship. It has to be possible to add a new book to an existing writer by using a form. See, I set up a search so that the user can search for a writer. When they foung it, they only have to push "Add new book to this writer" then a new blank form opens, just with the writers details.

I hope, that someboy can help me!

john