syntax error!

[tubar]

i look up a light bulb it opens a form. on that form i hit a button to get more info on that same lamp...but i get the error

SYNTAX ERROR (MISSING OPERATOR) IN QUERY EXPRESSION 'LAMP ID=95'

Here is the code i am using

Private Sub AddDeleteSuppliers_Click()
On Error GoTo Err_AddDeleteSuppliers_Click


Screen.PreviousControl.SetFocus
DoCmd.OpenForm "order specific", , , "lamp id = " & Me.Text91



Exit_AddDeleteSuppliers_Click:
Exit Sub

Err_AddDeleteSuppliers_Click:
MsgBox Err.DESCRIPTION
Resume Exit_AddDeleteSuppliers_Click

End Sub



suggestions?????

 

[boblarson]

You need brackets because the field name has spaces (another good reason why to NOT have spaces in your field or object names):

DoCmd.OpenForm "order specific", , , "[lamp id] = " & Me.Text91

 

[tubar]

very good part on the space mention....and thank you so much for the help

 

[tubar]

now the bonus question

what if the second form i am opening is an order form (data entry) how do i get the [lamp id] into the id box

 

[boblarson]

One way:

DoCmd.OpenForm "order specific", , , "[lamp id] = " & Me.Text91
Forms("order specific").Controls("lamp id").Value = Me.Text91

 

[tubar]

it all works perfect thanks again