Need to enter Value in Text box before enter in Primary Fiel

JAYESH

Hi Experts,

I have small query.
I have form on which i have text box which is Primary Key of the Table.

I created one Global variable and make a taxt box for this variable.

My query is i want to insert value in Text box which is Global variable and then i want to enter value in the other Text box which is primary key of the table.

Right now if i try its give me msg(primary key '' already exitst or you want to rename it ).

Can you give me idea how to solve this ??

Thank you

matttrax

You could use a dialog box and have it pop open to input the value. I think you could also set the DelayedInsert property on the form to true. That way it won't try to insert anything until after you leave the record.

May I ask why you need to have a value entered before the primary key?

JAYESH

Thank for the Reply

The Primary is combination of 2 field.

Eg . No - 101,
Date - 10/16/07.

Primary key is 10110/16/07.

So.. i want to do this...

Thanks..

DenSter

Matt's DelayedInsert suggestion should do exactly what you are asking.

JAYESH

HI..thanx for the information..

Its work..


Thank you once again..