Open form from combo box

ypma

Registered User.
Local time
Today, 15:58
Joined
Apr 13, 2012
Messages
643
Assistance would be appreciated. i have a Flash form which has a combo box ,
i am trying to open the Contact Details form with the record ID selected in combo box. My efforts open the form as a new record .
# DoCmd.OpenForm "Contact Details", acNormal, "", "Combo288.column(0)=[Forms]![Contact Details]![ID]", acEdit, acNormal#

I know some members do not wish to open Databases and would be happy to answer any questions you might have .

Regards Ypma
 

Attachments

Last edited:
Hi. Give this a try.
Code:
DoCmd.OpenForm "[Contact Details]", , ,"ID=" & Me.Combo288
 
theDBGuy: Thank you for getting back to me. Your suggestion produced an error message ," the form named is not recognised. or does not exist. "

I double checked the spelling of the Named form.
Any other suggestions ?
 
Bizzarely I think the issue is with the square brackets, try;
Code:
DoCmd.OpenForm "Contact Details", , ,"ID=" & Me.Combo288
 
Minty: Sorted many thanks . removing the brackets did the trick.

Ypma
 
Minty: Sorted many thanks . removing the brackets did the trick.

Ypma

Hi. Glad to hear you got it sorted out.

Hi Minty. Thanks for the assist.
 

Users who are viewing this thread

Back
Top Bottom