InfoPath & Access

I have an Access 2003 database which our staff access via InfoPath. Up until now when a new record was created they have not needed to know what the unique identifier created with that entry is. As I expand my less paper office I need them to know as they enter the record what that identifier is.

As Access 2003 hasn’t created it yet I’m at a loss as to how to generate it….if you see what I mean?

 

It sounds like you are auto-generating a unique record key in your access database. If so and with the caveat that I have never seen InfoPath, my understanding is that it can be used as a front end to create new records. In that case, it should just be a matter of having the key show up as an element on the InfoPath form.

However, the key won't be created until the record is created/opened so I can't think of any reasonable way for them to know ahead of time unless you set up some way to display the most recent previous record.

Maybe if you described what you want to accomplish and what drove the need for a change in the way you are operating, it would be easier to offer suggestions.

 

Before it was just logging when a quote to a client was done. Now it has to generate the actual unique quote number.

It turns out that when I was submitting it also cleared the form ready for a 'New Record'. If I don't clear the form then when I 'Submit' it keeps the info I have added and adds the Unique ID. It's always the simple things.

Ta,