This should be an easy one to answer.

I have two forms.

The first is a password entry form. It has a dropdown listbox of user names populated from a table in the database projmain.dbc. The user enters their password and clicks OK. The code compares the entered password with the official password in the user table. If it is accurate, the code calls the second form and passes the userName and userID.

The second form has two grids populated by views on separate pages, but the grids refuse to show the data. In fact the grid does not even show columns or headers--just a white box. (Sometimes they appear but I have yet to figure out why) I watch the OpenDatabases dropdown list on the tool bar and the projmain database appears to close when form1 unloads, and it does not come back for form2. I put the following code in load method of form two. My goal was to make sure eveything was open. I have all my tables and views in the DataEnviroment but they do not appear to open.
************************
IF USED("projmain")
wait window "Used"
ELSE
OPEN DATABASE \\server\database\project\projmain.dbc SHARED
wait window "Was Not Used"
IF USED("projmain")
wait window "Now is Used"
EndIf
ENDIF
This.DataEnvironment.OpenViews = 0
************************

The only wait window I see when this code runs is "Was Not Used"??

Any help would be great.

Thank you,
Jeff