Hey guys.
I am relatively new to Access 2010 and self-taught. I began a project from very few fields in one table in a MS SQL database. It has now grown to several forms and several tables. I am still in the process of "normalizing" the database.
What I have run into is the 255 field limit in a query. The query selects records from different tables to populate a form with tab controls and sub-forms.
After googling and reading I think a way to fix this for now is to use popup forms for specific form access when it is needed and not pull the information into the main form after the records is selected. I had also tried researching to see if a separate query for each tab would work as well.
I am trying a popup form to test this theory. However, I am having an issue of the popup displaying the fields from the record I am currently on.
Parent Form = frmProject
SubForm/PopForm = frmPOC_Popup
Parent/Child ID = ProjectID
Any help would be appreciated.
Thanks.