Search results

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.

I'm sure that's based in good professional sense. I, OTOH, have a very controlled situation with limited consequences.

For the record ( ho, ho ) I am the only person adding new members to this database, and the peak rate at which they are added occasionally exceeds the giddy pace of 1 a month! But I appreciate all the contributions to spell out the issues (which may become useful info elsewhere). Thanks.

Rather late, I thank you for this confirmation of what I found to work (in orig post). (Top 1 from ContactID Desc)

Thanks, good points clearly made.

Apologies for my confusion over the max value, and the record that has that. I did indeed want the whole record. And I remain surprised that there is not a simple criterium that selects only the highest value in a given field. (Due, no doubt, to my lack of understanding of how Access actually...