combobox opening to form SAMPLE

[teiben]

Does anyone have a sample database they can post, I looked though the samples and didn't find any. I have a combobox that's when a record is selected it's suppose to open frmResults. It's an unbound combo. I suspect its something to do with Me.RecordsetClone.Findfirst - but the code I've seen I guess I'm not applying correctly. help would be greatly appreciated

 

[Starman]

Assuming your combo box has two columns, the first being the PK and hidden and the second being the name of whatever and visible, in the After Update event of your combo box, put something like:

dim strCriteria as String
strCriteria="[fieldnameID]= " & me.[comboboxname]
DoCmd.OpenForm frmResult,,,strCriteria

Of course, you'll have to figure out what you want to do with the form the combo box is on (hide it, close it, leave it in the background, whatever).

 

[teiben]

Ooops, just realized it's a combobox -->listbox->form, would the syntax/results be any different?