Reference form in different databases
Posted on 2011-03-11
Hi I have 2 form in 2 databases:
1st form has following control: [Forms]![InputForm]![LoanNos] located in "Docs"
2nd form has following conrrol: [Forms]![InputForm-Main]![Loan Number] located in "Code"
Using Code :
im objAccess As Access.Application
Set objAccess = New Access.Application
objAccess.Visible = True
Using code above I was able to open form. However, InputForm-Main going to the 1st record. I need to be able to go the same record as it was in the form [Forms]![InputForm]![LoanNos] (located in db "Docs")
So, last line needs argument. Would you please help me with this one
Note: please do not provide comments not relevant to this question (something like I should be using one database)