Sharing Values between Forms

[MikeMcKeown]

Hi all,

I have an unbound control on a form which is based on the following fields from an Employee table(Empolyee_Id and Surname. When the users selects one the ID is stored.

i have another form which is based on all the details from the Employee table. If I was in this form and selected to open the form above which is not based on any table i.e. no fields list.

Is there a way that I can automatcially populate the unbound control on the form with the value from the other form.

I know you can do this between table, but can you do it with unbound controls?

 

[Crowley16]

as long as the other form is open, then you can put in the controlSource something like:

forms![frnName]![controlName]

--------------------
Procrastinate Now!

 

[MikeMcKeown]

I would put this is the control source and the row source would be blank?

 

[Crowley16]

eh, no, sorry, you should put this in the rowsource, that's what determins what shows up as things you can pick in a combobox...

the controlSource points to the value that you've actually picked...

--------------------
Procrastinate Now!

 

[TheAceMan1]

How are ya MikeMcKeown . . . . .

In the Load event of your Employee form, copy paste the following:

[blue]Me![purple][b]UnboundControlName[/b][/purple] = Forms![purple][b]DetailFormName[/b][/purple]![purple][b]ControlName[/b][/purple][/blue]

See Ya! . . . . . .