Recent content by John O'Malvern

Thanks for such a comprehensive answer. I'm sorry, but as I am likely to be the only user for the foreseeable future, and can personally train subsequent users, I will leave it as it is. It may, however, be useful elsewhere.

This worked a treat on your DB, of course!, and disables my subform as needed (great!) , but even when I enter two or three [at least] fields the SubForm only becomes enabled when I move to another record and back. I tried putting the enable code in the After Update event of the form, but that...

Spot on! Thank you; all has come right now. I think I may have been confused by too much space on the subform, anyway removing it (and maybe something else changed ) and it all works. In the unlikely event of another category being needed, I'll add a record to the table. I did notice...

So 'store that value in this field' is the right choice when the combobox is bound, thanks.

I did that to the Form's format property, but it hasn't changed the appearance of it, but I can scroll down to second or third records... I'll take another look at your example DB.

No not yet. catching up...

Thank you. I've ditched the Category Type column from tblContact_Categories, and also it's own ID numbering column (as I have two FKs to keep records unique.). EDIT - oops sorry, i didnt see your latest post, before writing what follows. I'll check it out now. I followed the example in your...

Err, should that be an option under Name on the property sheet using the All tab? I don't see it. EDIT - I had the frame of the form selected, not the body of the form (IYKWIM), and not it wasn't, but is now, and makes no difference.

I'm getting closer..., but the combo box remains empty. this is what I see: This is its row source: Control source is Category Type, bound column 1 for the subform, What have I missed? Many thanks.

GP George: That link doesn't work for me - HTTP 404.0 not found.

I don't understand the consequences of this choice: as I am sometimes inputting data here, I assume I need to 'store that value in this field' ,but when I select that option, I get a list of the fields on the main form, not any to do with categories.

Do you mean I should create a subform on my main form, and put a combobox on the subform? I tried to do that and the cmb always sits on the main form, not the subform.

I have a main form displaying fields from my table of members (PK ContactID) Members can have more than one category (Bike, car, commercial, minibus) and these values are listed in a table:- (I think that Category Type in tblContact_Categories is superfluous, and I will delete if so. ) At...

I do indeed. (And yes, thank God! :) ) 'Chill', guys!

It thought it had been established (very early on) that DMax will return the value of ContactID? (i.e. a number) What I was saying was that Top1... gave me the record, which is what I needed. I understand that autonumber *may* in some circs not assign the highest number to the last record.