passing record id from search form to main record form

[action]

I have created a search form (thanks to this forum) that locates a particular record, how can I pass this record (via userid field) to another form suitable for editing?

I can get the forms closing/opening but unsure how to go about the correct record being loaded in the editing form.

Thanks

 

[Tay]

If both forms have the field userid in them, you should be able to do this using the button wizard from the toolbox. Click on the button icon, put the button on your search form, and the wizard will start. Choose 'form operations' then 'open form' then 'next'. Then choose the name of the form you want to open, then 'next', then 'open the form and find specific data to display', 'next'. Then highlight in both columns of field names the userid field and then click the double arrow button between the columns, then 'next', choose what you want shown on the button, name it and end.
So when you've found the record you want via the search form, just click on the new button you've created and you will then be taken to the correct record on the other form.

 

[action]

Cool

Thanks, although it was not quite as simple as using the wizard as it was linked to a listbox I got the idea and have used the code to get the job done.

Cheers