I know this is a very basic question, But how do i write an SQL Statement in MS Access.

I need to have an SQL statement from a form.

The SQL will go to a specific record on a table

For instant
Go to Table1 at LastName = "Bob" or something like that

Thanks in advance whoever is helping me

Fastest way to create a SQL statement is creating a query. But it is still not the answer you need.
Create a Form for your table with one of the form wizards then add a Combobox or Listbox to your form. You will have an option to create a combobox which finds records in your form. But make sure wizard option is on.