Label hyperlink on form

[Guest]

Hi,

I have created a form which pops up when the database opens, on this
database I've got labels on my forms with hyperlinks to the tables in the
same database.

The hyperlink opens the table but only behind the form and also i need to
close the form to see the table.

Is there any simple way that the table can pop up in front of the form?

 

[Allen Browne]

The form with the labels is open in the wrong mode.

Open it in design view, and make sure its Popup and Modal properties are set
to No. (The Other tab of the Properties box.) If this form in opened
programmatically, make sure it is not opened in dialog mode.

If you open the tables, you have very little control over how the interface
works. You need to create a form so you can control the WindowMode and other
aspects. You can open the form in Datasheet view if you want it to look the
way a table does.