Form to Query to Form

  • Thread starter Thread starter George
  • Start date Start date
G

George

Hi,

I have a table which stored lots of personal details about
people on it, which they need to access and update
frequently. So I had decided to add a query with search
parameters of name and password. The parameter dialogue
box however does not mask the password as ****s so I
created a form with 2 text boxes. a user enters their
name and password and clicks "ok" and the query opens.
perfect! :)
Not being content with that, I've now decided that they
should actually see their results on a form, 'cause it
would look nicer. So I created a form based on the query,
and changed the "ok" box to point to the new form and not
the query.
But I get a form with no data on it. :'(
It's certainly better than seeing everyone's private data!

Can anyone help me implement this?
Cheers
G.
 
HI:

This is because the Form only displays data from a query or table. Forms
don't store data. Your second form, lets name it 'Login', should have the
unbound fields for [Username] and [Password] so it does not over write the
underlying table's 'Username' and 'Password' fields. In your query, which
displays the records in your main form, under the [Username] field add the
criteria form![Login]![Username] and under the query field name [Password]
add the criteria form![Login]![Password]. To keep users from cycling through
everyone's records just change the main form's properties from displaying
record selectors. Make the form continuous if a user has several record
sets. Is there not a password mask in your version of Access? Time to add
one or upgrade? ;)
 
Back
Top