Two same fields in a form Print & Save command?

[aligahk06]

DEAR ALL,


I have a form generated from table fields.
There are two fields that is same,say PO number.
I want if i update PO number at one place then the same PO number field automatically updated .
No need to enter two times PO number at two different field.

Moreover, I want a print command i and a save command in my form.
Any Help?



Rgds,
Aligahk06

[maximus]

First of all you can have two fields with the same name in a table, query.
You cannot have Controls (TextBoxes with the same name in forms)
The text Boxes in the forms have a Name and a Control source.

While the Name cannot be the same the controlsource of two text box in a form may have the same ControlSource.

Name is the identifier by which a control on a form is identified. Controlsource is the Field of a table to which the text Box control is linked.

So go to the properties of the Text Boxes and make the controlsources the same.

Now Changing the label of a text box in a form doesnot change the the Name of the text box nor the control source of the text box.

This code will print the active form. While creatin command buttons access wizard gives you the option to create print buttons. Try it out

Private Sub Command9_Click()
On Error GoTo Err_Command9_Click

Dim stDocName As String
Dim MyForm As Form

stDocName = "Form1"
Set MyForm = Screen.ActiveForm
DoCmd.SelectObject acForm, stDocName, True
DoCmd.PrintOut
DoCmd.SelectObject acForm, MyForm.Name, False

Exit_Command9_Click:
Exit Sub

Err_Command9_Click:
MsgBox Err.Description
Resume Exit_Command9_Click

End Sub