By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,392 Members | 1,556 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,392 IT Pros & Developers. It's quick & easy.

Data Not Insert To Table

P: 5
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
Expand|Select|Wrap|Line Numbers
  1. =Format("[OrderID];"000000")
but when i finished insert data into the form. the OrderNo is not inserted into the table.
Dec 5 '06 #1
Share this Question
Share on Google+
8 Replies


NeoPa
Expert Mod 15k+
P: 31,661
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?
Dec 5 '06 #2

MMcCarthy
Expert Mod 10K+
P: 14,534
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
Expand|Select|Wrap|Line Numbers
  1. =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
Dec 6 '06 #3

P: 5
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
Dec 7 '06 #4

P: 5
BTW, how to bound OrderNo. to related field.
Dec 7 '06 #5

MMcCarthy
Expert Mod 10K+
P: 14,534
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
Dec 7 '06 #6

P: 5
ok done. but the problem the data is not insert to table.
Dec 7 '06 #7

P: 5
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.
Dec 7 '06 #8

MMcCarthy
Expert Mod 10K+
P: 14,534
You will need to make sure the control source for OrderID is also set so it knows which record to update.

Mary
Dec 7 '06 #9

Post your reply

Sign in to post your reply or Sign up for a free account.