Combo Box

[BatmanMR287]

Hello All!
I need to take the value from a combo box and send it to a temp table. Any ideas?



Thank you for your time!

[pbaldy]

Options include using the AddNew method of a recordset or executing an append query.

[BatmanMR287]

@pbaldy
Got it to work with an append query that used another query to retrieve what was in the combo box. Now, there are two other fields that the user enters (date, and a short memo). I have these dumping into a temp table from the form. The problem now is that the number coming in from the combo box is being saved in the temp table on a different row than the other two pieces of data. I need to have all three pieces of data on the same row so I can save them to the main table.

[pbaldy]

Why not bind the combo to its respective field?

[June7]

All 3 fields should be in the same action. Post the query sql statement.

Why are you using a temp table?

[BatmanMR287]

The table is a policy that gets updated periodically with a new update that needs it's own row in the table. It is a many table, the one table was where I was getting the policy number from. The temp table is to combine the policy number with the new update then send to update table as a new row entry. I actually got that to work now.

New problem: I have a many table that has a combo key of policy number and administrative procedure number. There can be more than one of the same policy number with ascending AP numbers. I need to set up a combo box that filters out the additional duplicate policy numbers. Example: policy 4170 has 8 entries 1-8, in the policy number combo box I only need one 4170 to show. Can I filter the combo box to only show one of each policy numbers? I will have a subform show the AP entries with a different combo box for AP's.

[June7]

Maybe use DISTINCT keyword.

SELECT DISTINCT policy FROM tablename;

[BatmanMR287]

@June7
Distinct worked like a charm. Thank you very much June!!