stting focus on a form aswell as updating data.

[kingz2000]

hi,

using Access 2003, if I am using one Form.Is it possible to open another form and update this new form with a certain piece of data by pressing a button on the prior form?? How do I do that?

The 2nd form is linked to a data table, but I don't know how to set foucs on it from my 1st Form, and then to leave the Form on the particular dataset I want.

Thanks in advance

 

[Remou]

You can do this with code, for example:

Sub ClickMe_Click()

DoCmd.OpenForm "frmSecond"
Forms!frmSecond!txtNewData=Me.txtData
DoCmd.Close, acForm, "frmSecond"

However, if all you wish to do is update a table, considere running SQL from code.