Calculated Field Help

[judi98765]

Hi,

I need to string together three text fields to create a unique id (UniqID) on a form. I also need to pass this value to the next form. Can someone help? I've tried a calculated field, but the field calculates before all the data has been entered.

Thanks!

Judi

 

[Kryst51]

How about a DLookup that concatenates everything? Then you can set a text box on each form with the same DLookup, hence the same information.

See Here for examples, example 5 is what you want I think

 

[boblarson]

What is this "UNIQUE VALUE" for? I hope you aren't doing all of this to create a primary and foreign key for your tables. If you are you should not. You should be using a surrogate key (autonumber). You can still create your special number if that is for human eyes but for the keys and for the system you should just use an autonumber and not have it shown to users.