Recent content by gilgameshau

I have a solution now. I have my combo box whose value will just contain the key to reference the second table, though it may display a different field depending upon the column widths I have in its Column Widths property. I also have an unbound text field which will contain the extra field I...

In hindsight this second combo box is not a good idea. Yes I need to display the extra field from the combo box on the form. But I also need to have the value of this extra field so I can use it in subsequent calculations. Using the combo box simply gives me the reference key into the second...

I see your point. It has been quite awhile since I used Access and when I came into 2010 this time I saw the calculated fields and just started using them. They are now all removed and converted to VBA calculations in the form. I have also normalised the tables so that only a single reference...

Hello, I "think" I'm trying to do the same thing as kevin19 and I'm also having trouble. I'm trying to do this in Access 2010 which uses accdb but I've managed to export it to the earlier mdb (which actually eliminated all my calculated fields). This database is still a work in progress. In my...

Hi There I'm a moderately experienced VBA programmer but I'm a novice to Access. So while I will come in now and then with specific Access related questions; if someone else has a general VBA question I may pop in a suggestion or two.