Combobox not filling properly

  • Thread starter Thread starter Amy Blankenship
  • Start date Start date
A

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
 
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)?
 
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
 
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

Brian Bastl said:
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 said:
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
Click to expand...
Click to expand...
 
Dick D said:
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)?
Click to expand...

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
 
Back
Top