I am having problems with a control in one of my subforms.
In this subform, I've set the value of a combo box to default to the value
of a control on the main form.
When I view or first click into the new record line in the subform, the
default value appears to be working fine. However, when I start entering
data in the next control in this new record, the combo box value changes. It
seems to be defaulting to the name of the form itself.
I do have another form/subform which I set up the same way, and it seems to
be working fine. The only difference I can think of is that the one which is
working is based on two tables - not a table and a query. Maybe I have the
relationships set up incorrectly?
Any help would be greatly appreciated! Thank you!!
Klatuu - 30 May 2008 19:17 GMT
Post what you have coded in the Default Value property of the Combo.
Is there any other code in your form or subform the references this combo?

Signature
Dave Hargis, Microsoft Access MVP
> I am having problems with a control in one of my subforms.
>
[quoted text clipped - 12 lines]
>
> Any help would be greatly appreciated! Thank you!!
Zip00021 - 31 May 2008 05:46 GMT
Dave - Actually, I figured it out after doing this post! I'd been building
onto an existing database that wasn't set up how I thought it was... so had
to go in and change out some of the relationships and other items to make it
all link together correctly. Thank you for your kind and timely offer of
assistance!!
> Post what you have coded in the Default Value property of the Combo.
> Is there any other code in your form or subform the references this combo?
[quoted text clipped - 15 lines]
> >
> > Any help would be greatly appreciated! Thank you!!