Vacuum Sealed wrote:
Err, that's what a Domain function does ...

You still haven't shown us the hatd-coded sql statement that returns the
desired result for a specific Category. I repeat: open the query builder and
create the the query with a hard-coded value for the category (rather than
attempting to use the value entered in the form). Once you have that query
working, show us the sql. Why is this so hard for you to do for us?

I am suspecting you used one of those "lookup" fields for the Category in
the tblBreeds design and that is what is screwing you up, but I will not
know for sure. Seeing a hard-coded sql statement will remove or confirm that
doubt. Better yet, look at the design of that field in the table's Design
View and let us know if it's looking up values in another table. If so, let
the group know. They will advise you how to deal with it.

Anyways, I am leaving to go on a business trip now and someone else will
have to pick this up.

Bob

I took on board what you were trying to tell me.

Rather than trying to get the DMax to run the way of my OP, I decided to
chuck on a ListBox and set it's RecordSource via the QBE and set the BreedID
to MAX and hey-presto, full list of all breed category's and their
respective last numbers used as opposed to a single selection from the user.

This is visually heaps better as it updates automatically too as soon as the
user adds a new breed.

I truly appreciate how frustrating it must have been for you to get me to
understand your line of thinking and I thank you for your patience.

Cheers
Mick.