set value in form from search form

[red2002yzfr1]

I am trying to get a form to set itself to a certain record based on a search form result. Not sure how to get my search forms result populate another form.

 

[ions]

USe Macros for this.

1. GoToControl
2. FindRecord

 

[red2002yzfr1]

Thanks, it works fine. Sometimes you get so involved in the coding, the basics evade you.......Thanks again!

 

[Niniel]

I wish you had elaborated on this a bit more, I am trying to do the same, but am a lot more clueless.

 

[red2002yzfr1]

I wish you had elaborated on this a bit more, I am trying to do the same, but am a lot more clueless.

Niniel,

1. Create a Macro with these actions
2. GoToControl is the field that you want to set the value to
3. The FindRecord is where the value is coming from

Note: If you want the value to populate a field on another form, you will have to use the OpenForm action first.

These button(s) and fields are on a form that I call my "frmSearch" and that is where I put my fields from a query. In that form I put a field from the query that you will have to create in the query, which looks like this "NameScope: [projectname] & "; " & [projectscope]". This is where my "FindRecord" value is coming from. What this is doing is combining the fields in [] to search from. You can add as many fields as you see fit.

Create a button that in its click event runs the macro you created.

There are other buttons that you have to create to do the actual searching of your query, I am not sure if you need that information, but that is an important part of this.