Contact Manager Form

  • Thread starter Thread starter George Meier via AccessMonster.com
  • Start date Start date
G

George Meier via AccessMonster.com

I created a contact manager form for a specific part of my business. I want to use the same form for a different database for another part of my business. I have copied the form elements into a new design mode and have tried making a replica. In both cases, the databases are linked. Need to get the second database to be a choice in the Record Source area of Properties. Help please.
 
Hi, George.

A 'database' is never a form's RecordSource--a table or query is. If the
table you need is in another database, link it to yours with File,
GetExternalData, LinkTables.

BTW, you can import an entire form with File, GetExternalData, Import.

Hope that helps.
Sprinks
 
Sprinks,

Thanks. Sorry about the language issue. You're right, I am talking about tables, not databases.

What I did is this...have PRcontacts table. Want to use the form for a new table. But when I enter the new data in the new, replica table and remove the PRcontacts data, the PRcontacts data are removed from the original and replaced by the new data.

I want the PRcontacts data and the new data set to be descrete, unlinked. But both accessable by a form that looks the same.

Am I making any sense?...thanks again
 
Hi, George.

Sounds like you have the form's RecordSource property set to the original
table. Open the form in design view, select View, Properties, and click on
the square at the upper left hand corner of the window to display the form
properties. Change the RecordSource property on the Data tab to the name of
your new table (it should appear in the drop-down list).

If the fieldnames of the new table are not identical to the original, you
will also need to change the ControlSource property of each data control.

Hope that helps.
Sprinks
 
Back
Top