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

Form display error #Name?

P: 14
Hello all,

I have a form thats tied to my access database and all seems to work well except for one small thing.

Info on the code: whenever a consultant contract ends they get moved to an archive table, the form display three set of archive info (RDR, LBM, GSM).

RDR= consultant personal info
LBM= location info
GSM= business info

All data is archived correctly because i can go into the table and view the information, however when the form is display the GSM fields shows the following: #Name?

Can anyone assist?
Oct 12 '07 #1
Share this Question
Share on Google+
1 Reply

Expert 2.5K+
P: 3,072
Looks like Access can't find the fieldnames from the Controlsource in the recordsource of the form.
Are the fieldnames in the archive the same as in the original table?

Oct 12 '07 #2

Post your reply

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