Recent content by rjpeters

simple db holding cd details. main form holds cd title etc subform holds tracks, has fields [TrackNo] & [TrackCount] when I make new record I want to set TrackNo to previous TrackNo+TrackCount (will worry about validating that does not already exist afterwards) Should not be hard to do but work...

So far I have been unable to work out how to change the text (or background) color on alternate lines. - The report users claim that they cannot follow the lines, so I thought I'd try alternate colors. There must be a way (at least I hope there is a way) to find which line I'm on. - Russell Peters

I have a subform displaying in Dataview and I want to change it's font. Via the Options I can select what I want (or can put up with) but this only changes NEW views not the existing ones. Do I have to design a new subform or is there some way to alter the settings (possibly via VBA ?) - Russell...

Thanks, I retried that and have finally got it. The secret was I had change it's text to a previously valid entry so it could be saved before requerying. There is a possibility of it reentering the notinlist handler if I don't correctly add the proper entry but I will try to stop that when I get...

I have a subform with a lookup field (a couple actually) but if the actual lookup is missing (eg. a new composer) I have to add it to that table first _ can do that. My problem is that I cannot update the subform - it complains that I must save it first, but I cannot because required fields are...