help!!! difficult form problem

[dan]

I posted something earlier today regarding a problem I'm
having creating records with sub-forms. The post was
perhaps a bit complicated so I'm trying to simplify it and
hope that someone can help.

Basically, when I attempt to save a new record created in
the sub-form, Access complains that a certain mandatary
field cannot be null.

I have a combo box from which a user can select values,
but it does not constitute the primary key. I would
expect that upon selecting an entry in the combo that the
other fields in the sub-form would be populated, but they
are not.

I have got a similar implementation that works but this
one seems not to want to, and I can't find what the
difference is between the one that works and the one that
doesn't.

Can anyone help with some suggestions? I suspect that it
is something to do with how I'm binding the values, but
I'm at a loss at the moment.

Thanks in advance,

Dan.

 

[John Viescas]

What is the relationship between the data bound to the outer form and this
subform? What is the Record Source of the outer form? Of the subform? Do
you have the Link Master and Link Child properties set correctly? What
"required" field isn't getting set? If you're expecting to copy across
values from columns in the combo box row source, you must write code to do
that.

--
John Viescas, author
"Microsoft Office Access 2003 Inside Out"
"Running Microsoft Access 2000"
"SQL Queries for Mere Mortals"
http://www.viescas.com/
(Microsoft Access MVP since 1993)
http://www.deanforamerica.com/site/TR?pg=personal&fr_id=1090&px=1434411