Access/VBA - Display linked fields in Updateable continuous Form
Posted on 2011-10-18
Here is little background to my issue at hand.
I have a continuous Form where data source is a simple query from one table with no aggregate functions. This allow users to search, filter, sort and update single/multiple records, kinda similar to spreadsheet style. I have new requirement where another similar table needs to be joined (left join) to display few fields.
I tried following:
Create Left Join in underlying query of Form (sample: Select .... FROM TblFirst LEFT JOIN QrySecondTable ON TblFirst.SerialNum = QrySecondTable.SerialNum;)
Now Form is not Updateable, based on some previous recommendations i tried to change RecordsetType = Dynaset (Inconsistent Updates)... However i get into all kinds of trouble with existing filter, combos list throwing errors. So gave up on this idea..
Next I tried Dlookup to unbound fields but performance is way too slow for values to appear on screen. Its also affecting existing load and refresh times...
So based on above situation, i would like to know what else can be tried, that i can have updateable form with join fields displayed (read only) without suffering from performance issues.