Enter a value in textbox to open another form using value as the record number

[Mattbro]

Hello all,
I've a form-‘Data Entry’ linked to a table. To allow users to examine suspected duplication, I have a query ‘PtSearch’ which feeds to a form ‘PtSearch’. If the user is concerned about duplication, they can enter the serial number in a box on the form ‘Data Entry’ which starts the ‘PtSearch’ query and opens the form ‘PtSearch’. If there is any duplication, the user can see the serial number and record number of these cases. I have a textbox called Text14 in the header of the ‘PtSearch’ form, and I want the user to be able to enter the record number of the case they want to examine, into this box. Using the AfterUpdate event, I want the code to close the PtSearch form and open the Data Entry form at the record number they entered. My coding for this is;

Private Sub Text14_AfterUpdate()
  DoCmd.OpenForm "DataEntry", , , "Record Number = " & Me!Text14
  DoCmd.Close acForm, "PatientSearch"
End Sub

……and it hangs up on the second line of code.... "Runtime error 3075 syntax error-missing operator in query expression Record Number = xxx." Can anybody tell me what I am doing wrong? Many thanks,
Mattbro451

[RuralGuy]

Unless you put them in, Access does *not* have Record Numbers. Access also does not like embedded spaces in names so that field, if ir exists should have been called [Record Number] being surrounded with brackets. You code is also treating this field as a number. If is a string then you would need to enclose it in single quotes in this case.
DoCmd.OpenForm "DataEntry", , , "[Record Number] = '" & Me!Text14 & "'"
DoCmd.Close acForm, Me.Name

[Mattbro]

Ah-Record Number is a field in the table. Each entry on the table is allocated a record number (autonumber). It is also the primary key for the table. I am not sure whether that makes it a number or a string.....I assume number would be correct?
Anyhoo,
DoCmd.OpenForm "DataEntry", , , "[Record Number] = " & Me!Text14
seems to be doing the job nicely! Thanks for your help RuralGuy-your explanation has pointed me in the right direction regarding the hows' whys' and wherefores' of single/double quotes. Many thanks,
Mattbro451

Unless you put them in, Access does *not* have Record Numbers. Access also does not like embedded spaces in names so that field, if ir exists should have been called [Record Number] being surrounded with brackets. You code is also treating this field as a number. If is a string then you would need to enclose it in single quotes in this case.
DoCmd.OpenForm "DataEntry", , , "[Record Number] = '" & Me!Text14 & "'"
DoCmd.Close acForm, Me.Name

[RuralGuy]

Great! And to answer your question, AutoNumbers are Long Integers.