Opening a specific record from a switchboard using a combo box

F

flora8

I think I have a couple of issues:

I created a switchboard using the switchboard manager. It works fine.
However, I want to add a combo box so the user can choose to g
directly to a particular person's record. So I've done that, and th
code I've written behind it is:

Private Sub Combo24_AfterUpdate()
DoCmd.OpenForm "Main", acNormal, , StudyID = Me![Combo24]
End Sub

So my first question is - Is this right?
My second question is - I have the combo box on the switchboard, an
the drop-down populates with study IDs, however, I can't seem to selec
any of them. It highlights, but doesn't fill the field. What am
doing wrong/how can I fix this?

Thanks,
Jocely
 
F

flora8

Disregard the combo box question -- I hadn't set Allow Edits in th
switchboard properties to Yes. So now I can select a Study ID, i
simply doesn't do anything. Any ideas?

Thanks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top