Get combobox rows from one table and use it to populate another

[Lady_Jane]

Hi everyone,
I have a table (tbl_SampleActivity) that has fields SampleTypeID and SamplerID, among others.
These two fields are in a many to one relationship with tbl_SampleType (fields SampleTypeID and SampleDesc) and tbl_Sampler (fields SamplerID and SamplerName), respectively.

I would like to add rows to tbl_SampleActivity using a form.


One combobox is populated with SampleDescs and another is populated with SamplerNames.
I want to use these fields to populate tbl_SampleActivity with the related numberic IDs.

Can anyone help me out?
Thanks

[pbaldy]

Have you tried the combo wizard on a form bound to tbl_SampleActivity?

[Lady_Jane]

How do I bind my form to a table? I assume that Record Source needs to contain some kind of query. Right now it says SELECT * FROM tbl_SampleActivity. Does this mean it is bound to tbl_SampleActivity?

I have tried using the combobox wizard on the form. I can get it to populate the combobox with the necessary descriptions but it will not populate my table with the corresponding ID.

[Lady_Jane]

Alright, I'm slowly figuring out this form business...
I was confused by Access' terminology. I was thinking of it terms of I'm writing new records TO a table, but Access calls this table the "source". So If I set the control source to the table record I want to update, I can set the row source to the row I want to populate the control with. If I use a select statement to select both the ID column and the description column, I can then set the column widths to 0; whatever, which will hide the ID column.
yay.

[pbaldy]

Glad you got it sorted out.