Search results

Hi everyone I hope someone can help! I have 4 combo boxes on my form, all bound to tables. They are called cboDivision, cboServiceArea, cboArea and cboTypeofService. cboDivision populates cboServiceArea (depending on your choice), which then populates cboTypeofService. cboDivision also...

Hi there I'm using a subform which has 3 combo boxes in it - the 2nd one is dependent on what you pick from the first, and the 3rd is dependent on what is picked from the 2nd. I have code in the "on change" event procedure as follows: Option Compare Database Private Sub...

Hi Gemma 1) I don't know, but it does. I create a new record on the main form, and the subform goes blank. This is what I WANT it to do. 2) Really, I think I need a one-to-one relationship i.e. each person makes one complaint. BUT it is likely that SOME of the people we deal with will make...

Hi everyone I've tried searching, but nothing came up that helped, so I'm sorry if this has been answered before. I have a main form, which contains a subform. My problem is that when I create a new record on the main form, a new record is created in the subform (correctly) but if I go back...

That doesn't sound silly at all because THAT WAS THE ANSWER! LOL! I'm such a fool... Thank you! Could I just ask one more question - can I insert the word "Record" anywhere into that Caption, so that the label will read "Record x of y" rather than having to use another label just for the word...

Just tried it, and yes - same error! If I really can't solve it, then I'll just use the default ones for now.

I could just show the nav buttons etc, but I wanted to have it look a bit nicer, that's all!

The last line - Me!Navlbl.Caption etc

OK, thank you. Will see if that helps.

Hi all I hope someone can help me with this. I'm trying to put a custom record counter on a subform, but the code I am using doesn't seem to work. This is what I am using (on the subform module): Private Sub Form_Current() Me.RecordsetClone.MoveLast...