Access 2000: How to transfer between forms on the current record of both?

Hi,

I'm editing a database to make it easier for the user to input data. I have a large form (FORM_A), where a section is to fill in a contact name, address, telephone number and email.

I have added a seperate table (pre populated) where frequent contacts are stored (I've made a query to hold this as I needed to make some of the address fields in 1 field to fit in the memo field (address) in the FORM_A).

I then made a pop up form (FORM_B) to display the query using a combo box on the name to find the desired record. I want users to find a frequent contact if they wish and click a button to move to it from FORM_B to FORM_A obviously for the current record on both. The user should still be able to type new contact details in on FORM_A if it is not a frequent contact.

Thaks in advance! I couldn't find exactly what I was looking for on other threads. Let me know if you need more info!

re: Access 2000: How to transfer between forms on the current record of both?

Perhaps something like:

re: Access 2000: How to transfer between forms on the current record of both?

I bow to your superior knowledge! That worked a treat.

Thanks!