Generating unique ID from Combobox

[Splinters]

Stephen,

Welcome to my world!

When you don't break the ID up into its SEVERAL fields this happens!

Fortunately there's a short-term solution:

"[txtWoodIDcode] Like '" & Me.cboSpeciesSelect & "*" & Format(Date, "yy") & ":" & "*'"), 0) + 1

But they really should all be seperate fields.

Wayne

And that works just fine - thanks again.

And just in time for me to test with 3 new bowls done today!

Another one of those "I shoulda seen that one!" lessons...

And I know they should be, but both tables are pretty large and it would probably be a lot of work to redo them.

I'll keep it in mind for any other tables like this that I do - and will think about changing these when I have time to see straight.

Thanks,
Stephen

 

[fugifox]

Fugifox, many thanks for your advice - as you can see, Wayne's solution was quite easier than what either of us were heading for, but I appreciate the time and help. It cleared up some questions I've had on queries using VBA - so will come in handy in the future.

Again, thanks for the help.

Stephen

noprob, Anytime