View Single Post
  #2  
Old November 15th, 2009, 12:03 AM posted to microsoft.public.access.forms
Jeanette Cunningham
external usenet poster
 
Posts: 2,190
Default Combo box Subform Control Default

Hi Hannah,
here is a way to set the combo box to show the first record on the list.

Me.[NameOfCombo] = Me.[NameOfCombo].ItemData(0)

To make the subform control show the subform for the first item in the
combo, use something like this--

Call [NameOfCombo]_AfterUpdate


The above 2 lines of code can go on the Load event of the main form.



Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia




"Hannah" wrote in message
...
Apologies if this is here already - I can't seem to find it and I'm
seriously
stumped about how I do it.

I'm working on a main form which has a combo box and a subform control.
Depending on the option picked in the combo box, a different subform
appears
in the subform control. When you open the form however, there are just
empty
boxes. Is there a way to set a default subform to appear? I'm a bit of an
access newbie so all help would be very much appreciated!