By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
455,490 Members | 1,796 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 455,490 IT Pros & Developers. It's quick & easy.

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

P: 28

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!
Aug 6 '09 #1
Share this Question
Share on Google+
2 Replies

Expert 100+
P: 1,287
Perhaps something like:
Expand|Select|Wrap|Line Numbers
  1. If CurrentProject.AllForms("FORM_A").IsLoaded Then
  2.   Forms![FORM_A]!txtBox1 = Me.txtBox1
  3.   Forms![FORM_A]!txtBox2 = Me.txtBox2
  4.   ...
  5. End If
Aug 6 '09 #2

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

Aug 6 '09 #3

Post your reply

Sign in to post your reply or Sign up for a free account.