So you want to copy the phone number from one table to another. Can you tell me the combo box name, and the table and field names involved? Then we can do something with DAO or ADO depending on your needs.



mmcdonal

The first table's name is 'tblAfdelingenOpvTT'. This table includes the 'Naam afdeling' (=department) and 'Standaard telefoonnummer' (=phone number) fields.

The second table is called 'tblOpvTT' and has the fields 'Volgnummer' (=autonumber), 'Datum' (=Date), 'Naam afdeling' (=department), 'Naam personeelslid' (=name of a coworker) and 'Telefoonnummer' (=phone number field).

The form I'm using to insert the data is called 'frmOpvBijkomendeTT' and has the same fields as the table 'tblOpvTT' except for the 'Volgnummer' field that I did not include on the form.

I have build a subform on this form based on your idea that is called 'frmSubformAfdelingenOpvTT' and this one includes the fields 'Naam afdeling' (=department) and 'Standaard telefoonnummer' (=phone number).

Do you have all the data you need or do you need some more info? If I get it wright the phone number should be 'looked up' with a Naam_afdeling_after_update event.

Thanks again for trying to help me here...

Can you email me directly, and possibly send me the database if it doesn't have any sensitive data? Or a blank copy with no data? There has been alot posted and I will need some time to review this, possibly on Sunday (US, East Coast).

Will that work?

mmcdonal

I'm ok with that.

could you then give me your email? Or where can I find it?

Yes, look at my profile and click "Click to send email."

mmcdonal