Hi NeoPa,
Your fear makes sense but I and most of my fellows do the this on the MS-AccessProfessionals forum at yahoo.
We have enough confidence in each other - I can realize that I am newbie here so you might consider me a spammer which I do not mind.
But if you still have something to help you need to download the file which I am talking about. For a trustworthy website (at least for me is)
www.allenbrowne.com
I am using his sample for managing multilple instances of a form.
what I've wanted to accomplish is.
- A continuous form (frmMain) that has records of customers.
- Another form (frmClient) sort of detail for the customers in single form view.
- From the frmMain I wanted to open instance of frmClient filtered on a record
selected in frmMain.
- leave both the forms opened.
Then I will select some other record in frmMain and try to open
frmClient - the same way I did earlier.
This will create another instance of frmClient
with new record while the previously opened frmClient still shows its own record.
- It all works well.
- Then I added on current event of frmClient
- Private Sub Form_Current()
-
Forms("frmClient")!Address = Forms("frmClient")!ClientID & Forms("frmClient")!Surname
-
End Sub
there comes the problem.
but fortunately another MVP Bill Mosca the moderator of that Yahoo group
suggested me this....
- Private Sub Form_Current()
-
me.Address = me.ClientID & me.Surname
-
End Sub
may be I need to stick with the group / forum where people know me and they have a little trust in me.
Any way I am still thankful to you since you're helping Access community.
very best regards.
Ozair - Learning & Loving Ms-Access.