Opening a form and entering data from another form 2

[melt333]

Hi,

I am trying to move from one form to another, bringing the value in a combobox on the first form, to a textbox on the second form. This is probably a simple task, but I have been trying with no success.

Any ideas?

Your help is much appreciated,

Mark

 

[XP2000]

There are several ways to do it, but perhaps the easiest is to leave the first form open and set the Control Source property of the text box to something like:

=Forms!Form1![Combo1].[Column](1)

 

[KenReay]

Hi

If both forms are open then in the on open event of the second form

txtBox = Forms!MyForm1.cboMyCombo

using your own appropiate names of course.

If first form closes after openning second form then you could use openargs (see help) Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
UK

 

[melt333]

Doh, that was easy!!

But now I have a new problem. Nothing works on the second form except the close window button.

Help!!

Cheers,

Mark

 

[melt333]

Ignore the last remark - I had surpassed all levels of stupidness, but have now come through it to a stable state of confusion.

Thanks very much for all your help.

Mark