MS Access VBA query syntax

[macleodjb]

Hi guys, i'm hoping one of you pro's can help this novice out and write some quick code for me. I don't know the syntax to create a database query in a form module. Here's what i want the query to do.

1 - Query database and retrieve all records.
2 - With query result assign variable to each record
3 - Now i can take the variables and populate my textboxes.

Thanks in advance for the help.

 

[JoeAtWork]

Google "ADO recordsets Access". There are hundreds if not thousands of examples available already if you are willing to do a little research.