Combobox not filling properly

[Amy Blankenship]

I have a Combobox in a datasheet-style subform set with this query:

SELECT frmClassSetup.UserID, ([FirstName] & " " & [LastName]) AS FullName
FROM frmClassSetup WHERE (((frmClassSetup.OrganizationID)=[Forms]![Class
Setup]![OrganizationID]));


ftmClassSetup is a query I set up to use in this form, hence the frm prefix.

Set with the column widths 0" & 1", Bound column 1. However, when I preview
the form and click an item in the resulting drop-down, even though the item
highlights. The parent form is set to not allow edits, additions, or
deletions, but the subform has been set to allow these.

Any thoughts?

Thanks;

Amy

 

[Guest]

Since your subform control is calculated, it is, by definition, not
updateable.
How would Access know when to split what into the two fields (First Name,
Last Name)?

 

[Brian Bastl]

the subform is just another control on the main form. By not allowing
edits,additions,etc., you've made the form "Read Only." Have you tried
<allowing> edits,additions,etc and instead just locking all of the
individual controls on the form (other than subform control)?

HTH,
Brian

 

[Amy Blankenship]

That's what I wound up doing. Won't keep them from adding or deleting from
this form, but guess that will be a training issue...

Thanks;

Amy

the subform is just another control on the main form. By not allowing
edits,additions,etc., you've made the form "Read Only." Have you tried
<allowing> edits,additions,etc and instead just locking all of the
individual controls on the form (other than subform control)?

HTH,
Brian

I have a Combobox in a datasheet-style subform set with this query:

SELECT frmClassSetup.UserID, ([FirstName] & " " & [LastName]) AS FullName
FROM frmClassSetup WHERE (((frmClassSetup.OrganizationID)=[Forms]![Class
Setup]![OrganizationID]));


ftmClassSetup is a query I set up to use in this form, hence the frm prefix.

Set with the column widths 0" & 1", Bound column 1. However, when I preview
the form and click an item in the resulting drop-down, even though the item
highlights. The parent form is set to not allow edits, additions, or
deletions, but the subform has been set to allow these.

Any thoughts?

Thanks;

Amy

 

[Amy Blankenship]

Since your subform control is calculated, it is, by definition, not
updateable.
How would Access know when to split what into the two fields (First Name,
Last Name)?

Just as a FYI, the control is bound to the (hidden) first column. The
second column gives the user a more "visual" way than selecting "User 1".

Hope this clarifies;

Amy