View Full Version : blank form???


GH
10-20-2000, 01:52 PM
I have created a database for another department (Access97)and everything is functional except for one small detail.
The db opens and a welcome form opens, where
the user can select what to open from a tab strip. This functions ok, but the problem is that when you return to the form (after closing a table etc), all you get is the background of the form and nothing else.
Is this because the form is not refreshing or something? If so, what code do I need to cure this( if that IS the problem).
The form is frmMain.
Can anyone help me please
GH

Richie
10-20-2000, 10:42 PM
What do you mean by closing a table?

GH
10-21-2000, 10:46 AM
Hi Richie,
When you click on a tab you open a table in the same window. When you close the table (click x)you are left with the form but all you see is the form's background colour.
If I select Design View then Form View the tab and images etc reappear...weird!
GH

[This message has been edited by GH (edited 10-21-2000).]

GH
10-21-2000, 11:47 AM
I have worked around the problem.
Where I had written code in the MouseDown event for each tab I now run an OpenTable action in a macro, and the autoexec frmMain now appears as it should do when you return. I am now wondering if this may be a bug because I noticed that as soon as you clicked a tab everything on the form vanished as the table showed.
I,d still like an explanation for this though, for future ref.
GH

Jack Cowley
10-21-2000, 02:36 PM
I am not sure that I understand just exactly what you are doing but it would appear that you are opening tables directly for viewing. In Access the idea is to display the data in a table through a form. There are a lot of advantages to this approach so I might humbly suggest that you review your approach to data display.