I am taking the name to search from a form in a field called name.
I am firing a query
select * from table where lastname like
"[forms]![formname]![name]*"
but still the query does not give me the desired result.
could anyone please suggest me

Try this:

select *
from table
where lastname like Forms!formname!name & "*";

P.S. don't use name for your textbox as it is a reserved word in Access.