Add/Update a Forms recordset / table with combobox from different tabl

[NRogers01]

Hi All,

I have a simple form, 2 fields bound to Table 1. and a combobox from Table 2.

Users need to selecta value from a combobox (which is bound to table 2 ) and then fill in the 2 fields.I need to trap and add the selected Value's ID from the combox and update/insert that into Table 1, with the 2 captured field values.

Can i access the forms recordset? or interupt it in the BeforeUpdate event ?
If so how please.
else /or ..(I saw something about continuous forms.. is that the way to go?)..how do I do that ?

many thanks
Neal

 

[MajP]

can you provide the table and field names and if possible example data? You probably just need to run an insert query.