Combo Box to Populate a Subform

[Guest]

I have created a combo box in a subform to populate the subform. The combo
box does not work when I open the main form that the subform is in but it
does work when I open only the subform. Can someone tell me why the combo
box does not work when I use the subform within the main form and what I need
to do to fix the problem?

Thanks!

 

[John Vinson]

I have created a combo box in a subform to populate the subform. The combo
box does not work when I open the main form that the subform is in but it
does work when I open only the subform. Can someone tell me why the combo
box does not work when I use the subform within the main form and what I need
to do to fix the problem?

Thanks!

Could you explain what you mean by "use the combo to populate the
subform"? Are you copying values from the Column() property of the
combo into a form (don't!!!!) or trying to use the combo to select an
existing record? Could you post the actual VBA code that you are
using?

John W. Vinson[MVP]

 

[Guest]

John,

I am wanting to select a record off of a list and if necessary be able to
add a new record. The database is going to be used to keep track of Donors,
Activity, and Memorials. The main form is the Donors with 2 subforms;
Activity and Memorials.
I want to be able to pick a name from the Memorials list and the information
about the memorial be automatically filled in on the form. It would be
helpfully to be able to start typing the name of the memorial and it would
scroll through the list to find the name and if the name doesn't exist then
allow the user to add a name to the list.

In the After Update Event, I have tried the follow:

Me.RecordsetClone.FindFirst "[Memorials]![Memorial ID]=" & Me![Search
Memorials]
Me.Bookmark = Me.RecordsetClone.Bookmark

I received this from someone who was using this in a form that had no
subform and it was working. This gives me a "No current record' error.

I also, have tried using just Me.RecordsetClone.Find First
"[Memorials]![Memorial ID]=" & Me![Search Memorials].

Thanks in advance for any help that you can give me.