Combo box requery; update underlying table

I've asked this ? b4 and was able to get it to work with your help, but now
can't seem get it right in a new db.

I have a combo box control name cboUserID.
This autofills after combo box [Originator] is selected. The display is
correct, but the value is not retained in the underlying table.

The form is based on a query.
Row Source: SELECT DISTINCT ProjectTeam.[PT UserID] FROM ProjectTeam;

I need this value retained in the table.

Thanks! Mary

.

Relevant Pages

  • Two queries
    ... the Allocated table) I want it to display the product quantity from the ... How do I set up the query to do this? ... Prev by Date: ...
    (microsoft.public.access.queries)
  • Populate a List Box to select a record
    ... I use the same form to display different sets of records from a query that ... I limit or filter for different subsets by using the ... Prev by Date: ...
    (microsoft.public.access.modulesdaovba)
  • Re: Creatinig a database to update in alphabetical order
    ... Use a query with the ... appropriate ORDER BY clause to display the data, ... Prev by Date: ...
    (microsoft.public.access.gettingstarted)
  • pivot table not running correctly..
    ... i have pivots table in different Projects which were running correctly, ... suddenly all of them stoped running correctly and display this message ... "The query could not be processed: ... Prev by Date: ...
    (microsoft.public.access.forms)
  • Record Numbering in a Query
    ... How do I display the record number for each record returned from a select ... query without affectiing the underlying table? ...
    (microsoft.public.access.queries)
Loading