Q. Opening a form from switchboard . . ..

  • Thread starter Thread starter Jim Jones
  • Start date Start date
J

Jim Jones

Hi,

I realize this is a general question.

I would like to open one of my forms directly from a new switchboard
I've created.

However, this form relies on other forms being opened at the time, to
display the related fields properly, because in some fields I have
unbound boxes with =Forms, . . . . .. and so on.

How should I properly set up the given form, so I can open it directly
from my switchboard and display what I need the user to see ?

Thanks,
Jim
 
Rather than using =Forms, . . . . .. and so on use the DLookup function and you
won't have to ahave the other forms open.
=DLookup("[Fieldname]","NameOfTableOrQuery","....<Where Clause....")
Note - the where clause is optional.
 
Back
Top