Main and Sub Form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Question that is probably asked many times, however can not really find the
answer. I have a Main form to add records. This form has a sub form with a
combobox. User is able to select the name of the property in this combobox.
Would like a default property name in this combobox that shows up when
opening the mian form to create a new record. However, user must be able to
select a different property name.
Also, is it possible to set the default via a form outside the main form?
Thanks for your help.
 
If the combobox is unbound, you can set a default value in the combobox’s
property list.
If it is bound, you will need to move to the record with the desired value:

Me.RecordsetClone.Findfirst "[Value] = " & Me![ComboOrListboxName]
Me.Bookmark = Me.RecordSetClone.Bookmark

HTH
 
Back
Top