Run Time Error'3075': Syntax Error(Missing Operator) in query expression 'Name = Lee'

Hi,

pls try

my codes : DoCmd.OpenForm "Medical Record" , , , "Name = '" & Me.txtName & "'"

Select allOpen in new window

The error is due to the fact that text needs to be delimited with quotes.  Your original code, which does not use delimiters would work with a Numeric field.

For text, you need to enclose the name in quotes.  As in previous comments, this will work in most cases:

DoCmd.OpenForm "Medical Record" , , , "[Name] = '" & Me.txtName & "'"

Select allOpen in new window

However, this method will error with Irish patients like O'Hara and O'Malley.  

For NAME data,  the following method is preferable to avoid errors caused by apostrophes:

DoCmd.OpenForm "Medical Record" , , , "[Name] = " & chr(34) & Me.txtName & chr(34) 

Select allOpen in new window

Also, "Name" might need square brackets, as it is a special word in Access.

yea, thx , I solved by adding quotes at the back

DoCmd.OpenForm "Medical Record" , , , "[Name] = '" & Me.txtName & "'"

Select allOpen in new window

Good to hear. Don't forget to close the question :=)

thank bro