Problems with update table with combo box

[hlock]

Using a query I am pulling check information (check, check date, amount,
payee) from the AS400, using ODBC. Each check needs to be assigned to a
person for investigation. I have created a table called Investigator to
store the assignee information (it contains check # and name of
investigator). I would like to use a form to populate the Investigator table
with the check# from the query and the name of the investigator using a combo
box (which is based on a table).

Query: Outstanding Checks
Check
Check Date
Amount
Payee

Table: Investigator Names
Investigator

Table: Assigned Checks
Check
Investigator
In theory, I would imagine that the form would show the Check, Check Date,
and Amount and the Investigator. If the Investigator field is blank (meaning
it doesn't exist in the Investigator Names Table), I would like to click on
the drop down of a combo box and select an Investigator. If the Investigator
field is not blank (it exists in the Investigator Names Table), then I would
like to click on the drop down of the Investigator box and choose another
name.

I have tried this from multiple angles, but the closest I have come is to
show the check information and the Investigator box, but when I click on a
name, my computer beeps at me. I don't get an error message. I must be
missing it. Any suggestions would be helpful. Let me know if you need any
more information. Thanks.

 

[banem2]

Using a query I am pulling check information (check, check date, amount,
payee) from the AS400, using ODBC.    Each check needs to be assignedto a
person for investigation.  I have created a table called Investigator to
store the assignee information (it contains check # and name of
investigator).  I would like to use a form to populate the Investigatortable
with the check# from the query and the name of the investigator using a combo
box (which is based on a table).  

Query:  Outstanding Checks
Check
Check Date
Amount
Payee

Table:  Investigator Names
Investigator

Table:  Assigned Checks
Check
Investigator
In theory, I would imagine that the form would show the Check, Check Date,
and Amount and the Investigator.  If the Investigator field is blank (meaning
it doesn't exist in the Investigator Names Table), I would like to click on
the drop down of a combo box and select an Investigator.  If the Investigator
field is not blank (it exists in the Investigator Names Table), then I would
like to click on the drop down of the Investigator box and choose another
name.  

I have tried this from multiple angles, but the closest I have come is to
show the check information and the Investigator box, but when I click on a
name, my computer beeps at me.  I don't get an error message.  I mustbe
missing it.  Any suggestions would be helpful.  Let me know if you need any
more information.  Thanks.

Hi,

Table Assigned Checks, field Check should be linked with IDCheck/Check
table and Investigator should be linked with IDInvestigator/
Investigator table.

You will use this table to "connect" investigators with checks and
there are only 2 fields in use. However, you can show more details on
the form about both investigator and check (if needed). Populating
this table can be done in various ways - automatically, using list-
boxes to select investigator/check, using combo-boxes, etc.

Regards,
Branislav Mihaljev
Microsoft Access MVP

 

[hlock]

Thanks - but it still doesn't work. The Outstanding Checks query is pulling
information from several tables linked by ODBC. They do have primary fields,
but I'm not pulling or using all of them. I have the queries to Dynaset
(Inconsistent Updates) and none of them have unique values. Besides that - I
don't want to update those tables.

Basically on the Form, I want to choose a check from the Outstanding Checks
query and choose a name from the Investigator table and have the check and
the name populate the Assigned To table. The form is set to Continuous Forms
and looks like this:

Check Name C/B
Check Name C/B
Check Name C/B

The Check fields populate, but when I click on the dropdown for the Name
combobox and try to choose someone, I get a beep from my computer and nothing
happens. Any other suggestions?