Open form from combo box (1 Viewer)

ypma

Registered User.
Local time
Today, 04:40
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

  • Netball Comp manager.zip
    354.7 KB · Views: 67
Last edited:

theDBguy

I’m here to help
Staff member
Local time
Yesterday, 21:40
Joined
Oct 29, 2018
Messages
21,358
Hi. Give this a try.
Code:
DoCmd.OpenForm "[Contact Details]", , ,"ID=" & Me.Combo288
 

ypma

Registered User.
Local time
Today, 04:40
Joined
Apr 13, 2012
Messages
643
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 ?
 

Minty

AWF VIP
Local time
Today, 04:40
Joined
Jul 26, 2013
Messages
10,355
Bizzarely I think the issue is with the square brackets, try;
Code:
DoCmd.OpenForm "Contact Details", , ,"ID=" & Me.Combo288
 

ypma

Registered User.
Local time
Today, 04:40
Joined
Apr 13, 2012
Messages
643
Minty: Sorted many thanks . removing the brackets did the trick.

Ypma
 

theDBguy

I’m here to help
Staff member
Local time
Yesterday, 21:40
Joined
Oct 29, 2018
Messages
21,358
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

Top Bottom