Recent content by cmcritchie

Rich - Thanks, that's what Drew's solution does - however, the problem was knowing which form to make visible again after the new form was closed (but it's sorted now with Drew's solution).

Rich - Thanks, that's what Drew's solution does - however, the problem was knowing which form to make visible again after the new form was closed (but it's sorted now with Drew's solution).

Thanks Drew - that works just as I needed. Jack - the reason I don't want to leave the previous ones open is that the newer forms are smaller than the previous + so it looks untidy to have them open in the background.

Hi, I'm wondering if there is some VBA method to allow a user to close the current form & automatically reopen which ever form the user had open prior the current one. The reason is that the user may open this current form from a number of different forms & I need to know which one it was that...

Hi, Just wondering if anyone knows how I can reapply a form's filter after a new item is selected from a combo box on the form? I am using the value of the combo box in the filter and need to update the records displayed when a new value is selected. I can currently do this via a seperate...

Thanks Pat - I obviously need a trip to the opticians!!

I've managed to get the field names loaded by adding the names to a string and using it as the row source. However, due to the 2048 character length limit this doesn't work for tables with large amounts of field names. Any ideas how I could get round this? Thanks in advance. My code is as...

Hi, I have a combo box on a form and need to populate the combo box with all of the field names from a linked table, when the form is loaded. I am able to get each field name using the Fields.Name property of the TableDef but then can't add this string to the combo box. I thought I could use the...