Match the input data in table record

[soldieryap]

if i have a input column for the user to key in, for an example, it's a password column and user name column, after the user enter the password and user name, i have to check in the table "Members" and find the record, if it's matched, and process the next step... , the important thing is how to search the records in table . .. . because in the form, we can point like this: forms!xxx.xxx, but in table, i don't know how to do it !!! hope someone willing to teach, thanks

 

[skfoster]

You can use RDO recordset to open recordset and point to table. Something like: rst!mytablefield.

 

[JerryDennison]

RDO? Never heard of an RDO recordset. ADO and DAO, yes. What is RDO?

 

[skfoster]

Sorry, it is DAO.

 

[Guest_imported]

Ok soldier, what you need to do is to create a custom Query for the table 'members' and as a criteria, use the 'user_name' and 'password' fields of the input form, will look something like this:

SELECT members.*
FROM members
WHERE members.user_name = Forms![input_form]![user_name]
AND members.password = Forms![input_form]![password]

if no records are retrieve, the user doesn't exist in the table.