Data Not Insert To Table

[prozone]

There are 2 related textbox in my form. one is OrderID the primary key and another one is OrderNo. So I insert this expression in OrderNo

=Format("[OrderID];"000000")

but when i finished insert data into the form. the OrderNo is not inserted into the table.

[NeoPa]

Probably two separate problems.
1. Format([OrderID],"000000")
2. OrderNo must be bound to the field for it to update the table.

This really is a strange way to use it.
Surely you only want to set it for new records and not for records that already have a value?

[MMcCarthy]

There are 2 related textbox in my form. one is OrderID the primary key and another one is OrderNo. So I insert this expression in OrderNo

=Format("[OrderID];"000000")

but when i finished insert data into the form. the OrderNo is not inserted into the table.

Check that the control source property of the OrderNo textbox is set to the related field in the table.

Mary

[prozone]

Probably two separate problems.
1. Format([OrderID],"000000")
2. OrderNo must be bound to the field for it to update the table.

This really is a strange way to use it.
Surely you only want to set it for new records and not for records that already have a value?

yes, its for new record. i will use OrderNo for search function not OrderID

[prozone]

BTW, how to bound OrderNo. to related field.

[MMcCarthy]

BTW, how to bound OrderNo. to related field.

Open the properties of the control and under the data tab set control source to the relevant field.

Mary

[prozone]

ok done. but the problem the data is not insert to table.

[prozone]

Open the properties of the control and under the data tab set control source to the relevant field.

Mary

i have set it but the problem is still there.

[MMcCarthy]

You will need to make sure the control source for OrderID is also set so it knows which record to update.

Mary