Read value from field on other form

[Anna987]

Hello,

I'm trying to read the value from a field in a form in to a field from another form. (read value from controlfield in form1 in to controlfield from form2)
In the fieldbox property controlsource from form2 i type this =Forms!form1!field1


The form1 is open and this field is on the mainform.
Form1 is in the same database.
I get the error "Form1 not found"
Can someone help me out...

Thanks in advance.

Bieke

[Welshgasman]

=[Forms]![frmDailyEntry]![txtWeekDay]

works for me. the [] was put in by Access.
So I would say you have the formname wrong as Access does not lie.

[Anna987]

I'm sorry, i realise that the form1 is from another database, Is there a possibilty then ....?

Bieke

[Welshgasman]

You can reference another DB, but I am not sure how you would then reference the forms.

See if this helps Open Form in another DB

I believe if you open that form in the other DB, then it will become part of the Forms collection, so the same syntax would work.

[Anna987]

I've find another solution, with a shared table from one database to another.
Thanks for helping.

Regards, Bieke

[ano]

i would opt for dim db1=otherdbpath with sql recordset

[ano]

to open a 2nd database use something like this:
as u see the msgbox can also display ur field from subform
just change ur strdb and add the code where u like to use it
this is loaded once at startup form calling displayform

 Sub DisplayForm()
Dim strDB As String
Dim db1 As Database
Dim strSQL As String
Dim rs As Recordset
strDB = "C:\cctv\rownumbering.accdb"  '2nd database not in use
Set db1 = OpenDatabase(strDB)
strSQL = "Select * from transactions where [customerid] = 5"
Set rs = db1.OpenRecordset(strSQL)
rs.MoveFirst
MsgBox rs.Fields("TransactionAmount") & "/" & rs.Fields("customerid")  & Forms!form1![salary changes]!Name
End Sub


Private Sub Form_Load()
DisplayForm
End Sub