I've already posted this in the MS Access forum, but I might get more responses here..
I currently have a database in Access 2007 that I want to convert to SQL Server 2005, but I want to keep Access as the front-end so that I can continue to use the forms. The tables and queries will be in SQL Server.
The form I'm having trouble with has a drop-down menu with a list of codes. It has a subform which displays records matching the code selected. The information comes from a query that selects certain records from a table (based on other criteria). This is all designed using link master fields and link child fields. The problem is that when I upsize to SQL Server, this feature doesn't work anymore. Nothing happens when I select a code from the drop-down menu. I know the query works, and the form does get records from it, but changing the code doesn't do anything. I'm guessing that the problem is with link master fields and link child fields. Is there any way to make the linking work?
Thanks
I currently have a database in Access 2007 that I want to convert to SQL Server 2005, but I want to keep Access as the front-end so that I can continue to use the forms. The tables and queries will be in SQL Server.
The form I'm having trouble with has a drop-down menu with a list of codes. It has a subform which displays records matching the code selected. The information comes from a query that selects certain records from a table (based on other criteria). This is all designed using link master fields and link child fields. The problem is that when I upsize to SQL Server, this feature doesn't work anymore. Nothing happens when I select a code from the drop-down menu. I know the query works, and the form does get records from it, but changing the code doesn't do anything. I'm guessing that the problem is with link master fields and link child fields. Is there any way to make the linking work?
Thanks
