taking text from 1 form to open data in another form

[swarv]

All,

I have a login form where the user types in their username and password. It looks up these from tbl_users. If the username and password match what is in here then the button loads another form. Also if it does match then it copies the username and date to tbl_logonname.

I am asking how is it possible to do this: say Martin logs on and types in correct password. Loads the for frm_homepage and display martins record from the table users (not tbl_users).

Many thanks

Martin

 

[CyberLynx]

Martin, it still isn't quite clear what you want to do.

Is it that you want to populate the frm_homepage with Records that were entered by the User Logged in? This would of course mean that each record that would populate the Form must contain a reference to the User.

More detail please.

.