Combo to Populate Form

[Steven547]

Ok...It's been almost a year and 1/2 since I've gotten this "deep" with access programming, so forgive me if I've forgotten the simple steps.

I have a form that the user enters information into to store into a table (TABLE A). There is another table (say..TABLE B). Table B is linked to the main database server. Table A contains some fields from Table B, but additional ones for user to populate. Follow? Ok...On my form, I would like the user to be able to select an account number from the MAIN database server (TABLE B combo box) and populate the form. After user changes info, or adds, etc, it then saves to TABLE A. I have completely drawn a blank on how to do this again. Am I to create a query, and have the form based of the query? or?
Thanks for any and all help!

 

[Remou]

Have you considered setting up the combo with all the relevant fields? These can then be referred to by column number and used to update the relevant controls in the After Update event of the combo. The form would be bound to table A.