open form based on combo box value

[moneypennie21]

Hi I am trying to use a combo box on a dashboard form to open another form to a specific record. I have tried variations on the openform command and openargs but I am quite new to access so I am probably doing something wrong somewhere. I have attached a test version of a simple database that shows the problem I ma having the code on click event of command5 button is



Private Sub Command5_Click()
DoCmd.OpenForm "Frm_Table1", acNormal, , "Visit_ID = " & Me.Combo23 & ""
End Sub

Please can someone advise what I need to do to resolve this?

Thanks

JBranch visit access.zip

[ranman256]

DoCmd.OpenForm "Frm_Table1", , , "Visit_ID = " & Me.Combo23

your code is correct providing:
the table field name is: Visit_ID

the field is numeric
the combo value is not null
the combo value IS bound to the correct column#

UPDATE:
your combo column is bound to ID, not VISIT_id

[moneypennie21]

Hi ranman256,

Thank you for the update, how do i change this? I have tried changing the bound column property on the combo to 2 but this doesn't work properly either. what do I need to do to resolve?

Thanks

J

[moneypennie21]

I have made a change now as I wanted a random ID generated which I have done after a fashion but now the format of the field in the table is text even though the result is a number I have tried adding [] round the field name but I get run time error 3075

Syntax error (missing operator) in query expression '[visit_ID] = 237366 (this is the id I am searching for so part of the code is working)! I have added an updated version of the db to see if anyone can help with this

the code I am using is


Private Sub Command5_Click()
DoCmd.OpenForm "Frm_Table1", acNormal, , "[Visit_ID] = " & Me.Combo23 & """"""
End Sub




Thanks J

[moneypennie21]

SOLVED under https://www.accessforums.net/showthread.php?t=76103