A
Antonio
I have a form (Form1 set to continuous forms) containing a sub form (SubForm2
set to single form) based on the same table.
SubForm2 is used to input information that is displayed in Form1 after a
record is added. (I use [Form1].Requery in the "Lost Focus" event of the last
text box in SubForm2 to cause the "refresh" of Form1).
Is there a way to add code to the "On Click" event of a data field on Form1
that will display the same record in SubForm2 without having both forms
linked via Master and Child Fields?
Originally I had the forms set up with the traditional "Linked Master/Child"
fields..but when I added [Form1].Requery to text box in the sub form, I ran
into a problem after the user added a record in SubForm2. The entire form
would get stuck on whatever record was selected in Form1 and each time I
tried to add a record in the sub form nothing happend.
set to single form) based on the same table.
SubForm2 is used to input information that is displayed in Form1 after a
record is added. (I use [Form1].Requery in the "Lost Focus" event of the last
text box in SubForm2 to cause the "refresh" of Form1).
Is there a way to add code to the "On Click" event of a data field on Form1
that will display the same record in SubForm2 without having both forms
linked via Master and Child Fields?
Originally I had the forms set up with the traditional "Linked Master/Child"
fields..but when I added [Form1].Requery to text box in the sub form, I ran
into a problem after the user added a record in SubForm2. The entire form
would get stuck on whatever record was selected in Form1 and each time I
tried to add a record in the sub form nothing happend.