Using a combo box to open form and locate record.

[LClarke]

I have a combo box in a welcome screen that displays records, when you click on a record I want it to be able to open a different form with the details of that record that was selected displayed. Any help? Below is a SG of the combo box.

[ranman256]

In a table put 2 columns: caption, form.
User sees the caption column, but the click will open the form.
if cboBox is bound to form column, then:
docmd openform cboBox

[LClarke]

My combo box is already linked to a form of which the records are being selected from, as you can see there are two records on that form, when one of those is clicked, it then will open the form with the details of the record in.

[orange]

Based on your posts #1 and #3, I understand that

OPEN EVENT LIST when clicked, will display the

Open Event Details combo.

Then, if you select a row in the combo.you want to open another Form using the value you just selected in the combo.

So in the afterUpdate event of the combo, open your new form and use the selected value for whatever purpose you need.

If I have misunderstood your post, please clarify with a sample of the before and after data you are trying to display in your Form.

[LClarke]

I have two forms, one is a split form seen below which is opened by clicking the button

And the combo is always there and opens a details record form seen below

I have got it so that by clicking the record opens the form however it doesn't go to the record in the combo box I click, it goes to the first record in the table, how do I make it go to the record I click in the combo box?