Creating a unique item number using two existing fields

[JLongo]

Can you attach my copy with your fix of the database please??

[weekend00]

How to attach a file?

[weekend00]

Here it is.

[JLongo]

This is why Access and coding kills me lol. Your copy works so I'm going to stick with that one. Thank you for all your help...this is all i needed.

I will leave positive rep for you...thanks again!!

[weekend00]

You are always welcome.

[JLongo]

Weekend,

The item number generated is not being stored in the generateditemnumber field within the table?

Do you know why?

I need this stored so I can query this information later.

Thank you.

[weekend00]

the textbox is not bound to the table. you may need to save it to table by some coding, using update query.

[JLongo]

Do you have some steps I can follow to accomplish this.

I'm haven't had much experience with Access (2003).

[weekend00]

1. bound text box "GeneratedItemNumber" to field "GeneratedItemNumber";
2. create event for combo box "Category" as following:

Private Sub Category_BeforeUpdate(Cancel As Integer)
GeneratedItemNumber = DLookup("CategoryAbbr", "tblcategory", "category='" + [Category] + "'") & [ItemNumber]
End Sub

[JLongo]

Beautiful!!

Thanks again.