I am using a bar code scanner to enter number into Account field. I need a conditional script to enter the date into field "Adate" after the bar code scanner enters the acconunt number into the "Account" field and t6hen create a then create a new record. The new record has to be there so the bar code scanner has a new field to input into.

The only way I can think of to do this is a conditional script. I keep having issues with any script I write. Any Ideas?

Thabks a milllon!

Suggest you post your file so we can look at it and see what you're doing.

Not sure what you mean by "conditional script": what exactly is the condition here?

If your scanner appends some kind of suffix to indicate the end of scan, then you can use that to trigger a script. Ideally, the suffix would be a return or a tab, so your script can run OnObjectSave.

The new record has to be there so the bar code scanner has a new field to input into.

It would be better to scan into a global field and create a new record only when actually needed. This way the date can be auto-entered on creation. After creating the record, clear the global filed and - if you expect another scan - place the cursor in it.