Form/Field Behavior

[Tom]

I have a continuous form with a combobox. Rowsource for the cbo is a
lookup table with 2 fields (chID and chName).

Intent is to select an item from the cbo and have it displayed in the
cbo with the second field from the look up table displayed in a text
box (txtName) on the form.

Recordsource for the form is an inner join between the main table and
the lookup table with all of the main table fields and chName.

The working table only stores the chID value - not chName, since I can
always look that up.

So I would expect that when I select an item in the cbo, txtName would
immediately display the corresponding chName value.

That's not happening. If I close and reopen the form, it will fill in
as expected. If I put me.requery in the cbo's afterupdate, it fills
in (but thats undesirable since it changes the active record). But if
I just move off the dirty record txtName stays blank.

How do I get txtName to fill in after selecting a value in the cbo
without requerying the form or otherwise saving the record.

Thanks

[bsn]

"Tom" <rt*****@swbell.netskrev

Intent is to select an item from the cbo and have it displayed in the
cbo with the second field from the look up table displayed in a text
box (txtName) on the form.

You set the secon field in the afterupdate event in cbo...

Cbo_AfterUpdate
Me.txtName = cbo.Column(1)
End Sub

Bjarne

[Tom]

TBjarne:

Thanks - but that doesn't work. The problem with that approach is
that the control source for txtName is chName from the lookup table -
I end up getting an error msg saying "The changes you requested to the
table were not successful because they would create duplicate values
in the indes, primary key or relationship..."

I can't make the txtName field unbound since this is a continuous form
with multiple records displayed...

Any other thoughts?

Thanks

Tom

[bsn]

"Tom" <rt*****@swbell.netskrev>

Any other thoughts?

Make the formular to a datasheet...
Use the same code (other mail...)
Bjarne