troubleshooting Question

ACCESS 2007 - VBA - Forms

Avatar of shmz
shmzFlag for United States of America asked on
Microsoft AccessMicrosoft SQL Server 2008
8 Comments1 Solution239 ViewsLast Modified:
Hi,

I have an application in Access 2007.  The form were related to non related tables in sql. I have created a relational db in sql and as a result I made changes to database columns and adding fk's....

I have problem with the form interface. I am not familiar with access but here is the problem I have:
The 'FORM' has a control source query in its control source, it is for example: select * from employee.

Then there are drop down boxes, which they also have their query.I select values from the dropdownbox and they wil be inerted into employee table. upon pressing enter key.

The form WAS deigned so all fields in the form had the same name of employee table columns, where information is suppose to be stored.
 but now it is different. now instead of having salaryRange in employee table, I actually have only SalaryRangeID as a Foreign key in employee table.

if I select SalaryRange from salary dropdown box (which is populated using select SalaryRange from tblSalaryRange), this field (SalaryRange column) doesn't exist in employee table anymore and form generates error. (#NAME?)

how can I solve this problem.
Someone mentioned use of VIEW but I have no idea how that can be done.

Many Thanks in advance.
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 8 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 8 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros