Appending linked tables dynamically in Access 2000

[BFP]

I have a table (say Table A) that is getting data from a linked table (say Table B). I set up a combo box in a form for Table A to show the data from Table B, but I can't seem to figure out how to append Table B<br>(dynamically) from Table A's combo box. About all I can do is enter a non-Table B value in the combo box and have it show up in Table A. <br><br>Next, I would like the newly entered data in table B to automatically refresh the combo box for the form for Table A. <br><br>Any ideas?<br><br>Thanks in advance, <br><br>--Dan<br>