Self populating a table from another table with a form

[Crawforda]

I have 2 unlinked tables and a form. The first table contains basic information (unique number, part # & Qty), this table is updated daily from another database (not compatible, and off limits to me).
The second table contains details of details related to the unique number, part # & Qty.
The form is used to enter the details & the part details.
On this form I am effectively duplicating the same information as in the first table, what I am trying to achieve is to be able to type the unique number into the form, and for the form to 'fill in' the part # & the Qty, and for this to update the second table.
I can't create a link between the 2 tables, because once the table updates, all the previous entries on the second table will have no reference.
Is there a way to copy information from specific records in 1 table to another table?
I hope that I've explained this properly, and that someone can help me.

Any help would be greatly appreciated.

Many thanks in advance

Anthony

[This message has been edited by Crawforda (edited 01-18-2002).]

 

[D-Fresh]

Create a 3-column combo box on your form with a source of your first table and bound to your second table. Put unique number, part #, and qty as your columns. Make your bound column the first one, and hide the other two columns. Do this by setting the column widths to 1;0;0 (1 inch for the first column, 0 for the second and 0 for the third.). In the After_Update event of the combo box, assign the part # and qty to two text boxes, bound to your second table. To do this, use the following code...

Me!PartNo = Me!cboUniqueNo.Column(1)
Me!qty = Me!cboUniqueNo.Column(2)

The columns of a combo box are just a zero-based array. This will assign the unique #, part # and qty to your second table. Hope this helps.

Doug

 

[Crawforda]

Hi Doug,

Thanks for that tip, it put me on the right track.
In all the times I was checking the help files, not one of them suggested a combo box. Now it seems really obvious.

Anyway, many thanks again

Anthony