Forms - display information base on name

  • Thread starter Thread starter Mike
  • Start date Start date
M

Mike

Hi All,

I created three tables and each tables is linked by keys
(primary key or foriegn keys). I also created a form to
displayed all the information about the user. I have a
query that will ask me for the user name and when I type
the user name, the form should display the information for
the particular user. Instead, I got a blank form with
nothing displayed. How can I solve this problem? I just
need to displayed the information base on the user when
entering it in the query.

Thnaks for the help...

Mike
 
Mike,

If I understand this correctly, you have a query which
connects the three tables, and the form record source is
the query (if not, this is what you need to do).
If the above is correct and your form still displays
nothing, then most likely the problem is in the query, not
the form. In order to check this try the query on its own
(not the form), to see if it does what you expect it to.
In order to make the query ask you for a user name and
show only the pertinent records, you need to put in the
first criteria line (in query design view) something like:
=[Please enter user name]
in the respective field.

Nikos . (nyannaco at in dot gr)
 
Back
Top