Search results

Thanks for the warning. As things stand in my database I'm highlighting only the current record and not anything else, and the highlighting seems to work OK when the record appears from off the screen using the scroll bar. I'll bear it in mind,though, if I get to feeling adventurous when the...

I thought I'd copied the statement faithfully but, prodded by your comment, I went back and realised I hadn't included the original = sign. Now that I have, it works. Doh! (Well, in my defence I can at least plead mitigation due to the absence of any guidance on using IIf in the help files.)...

I'm trying the code that Oldsoftboss posted (thanks very much, Oldsoftboss - it may solve a huge problem) but I have a snag that sounds similar to yours. I've tried creating the form fields after the highlighting control, and it does make a difference, but I think there's something else that's...

Rich, That's brilliant - having Subform 2 in the footer of Subform 1 solves all the problems (well, until the next set at least). When I think of all the time and frustration I could have saved if I'd come to the forum sooner..... or, indeed, if Access had said anything about subforms being...

Rich, I don't know if this is going to help, but here's a little more meat on the bone: Main Form contains companies. Subform 1 lists, in Continuous Forms view, every meeting we've had with the company selected in Main Form. Subform 2, in Single Form view, gives a buch of details about the...

Not sure about making that link; like Subform 1, Subform 2 is a child of the Main Form, and the only options available for links to the Master are the fields in the Main Form - as far as I can tell, I can't link to any field in Subform 1.

That's a fair question. The short answer is that I got an error message telling me that the form wasn't open - but I can't account for why. The brief synopsis of what I'm ultimately trying to do is that I want the record in Subform 2 to match the record that's selected in Subform 1. I'm...

In case it helps, the following code (which was already present - I had nothing to do with it) appears in the Global Code module and seems to match what's suggested in various postings about the IsLoaded function: Function IsLoaded(ByVal strFormName As String) As Integer ' Returns True if the...

Thanks for the idea of using Me.Parent.Form("SubForm 2"). Unfortunately, though, it results in another "error 13 Type mismatch". You rightly surmised that "Subform 2" is not the real name of the subform, but I've double-checked the real name to make sure it's correct in the code and have also...

I realise that both the IsLoaded function and the issue of how to refer to sorms and subforms are covered extensively in these forums, but I've trawled through and tested many of the suggestions and still cannot get Access (I'm using Access 2002) to do what I'd have thought should be a pretty...

Pat, It looks like there's some sound advice in what you've said - it certainly makes sense! I particularly like the sound of the synchronised subforms, which may well get araound the problem that sparked all this off: the fact that I can't have a subform within a subform when it's set to...

I can't seem to restrict the records in an unbound combo box control in a subform. The background: I've built a contact database to track meetings with individuals from customer companies. Each company can have several individuals, each individual can go to several meetings and each meeting...