ComboBox Selection To open Form with recordset

[Guest]

I am trying to Create a form with a combo box that once you select a name it
opens another form with the record information for that name.
I have the combo box set to select the name, but I can't get it to open the
other form (and of course since it won't open, there is no information)

I am sure this is a fairly simple task, but I have been out of Access for
about 2 years and I am very rusty.
Any help is very much appreciated.
Michael

 

[Larry Linson]

I am trying to Create a form with a combo box that once
you select a name it opens another form with the record
information for that name. I have the combo box set to
select the name, but I can't get it to open the other form
(and of course since it won't open, there is no information)

If your Combo Box is named "Combo0" and has columns for "BoatID" and
"BoatData", and you want to open "frmBoats" which has "tblBoats" as its
RecordSource and the key of tblBoats is "BoatID", then put the following in
the AfterUpdate event of Combo0:

DoCmd.OpenForm "frmBoats", , , "[BoatId] = " & Me.Combo0

Larry Linson
Microsoft Access MVP