Hi All,
I have a form with a standard combo box and 5 tabs in A2003.
On Form Open, I set Me.Detail.Visible = False and in the after update
event of the combo set Me.Detail.Visible = True,( to open form with no
info showing ) I've noticed something quite strange.
I open the form ( details are not visible ) select any record ID with
the combo and the details come up OK. I click anywhere on the
tabcontrol and it immediately goes back to the first record ( ID 1 ).I
select a different ID with the combo and all is well.
Now, if I start again and open the form, select any ID from the combo
and let those details come up then immediately select a different ID
from the combo box, I can now click on the tab control and all is
well.
If I leave the form detail as the default ie Visible, no problems.
Any ideas as to why the clicking the tab control under these
circumstances whould throw back to the first record in the
recordsource table?
Is there a more efficient and elegant way of opening a form as blank,
and only showing the records once the user has selected a record ID?
Regards
Karl