Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
bansi
Starting Member
5 Posts |
 Posted - 2006-03-26 : 07:42:08
|
| ok guys very simple questioni have manually built my form in Access 02. Now i want to bind a particulr control to a table - ie. when the user hits 'Submit' the record will get written to the correct tables. simple data entrywhat am i doing wrong? i have a table called tblShipping, in which there is a field called Goods. in the control source i have the expression: =[tblShipping]![Goods] but this is not working... any help pls? |
|
|
timmy
Master Smack Fu Yak Hacker
1242 Posts |
Posted - 2006-03-26 : 18:47:53
|
| OK - first thing: If you data-bind on Access forms (which is what you're doing), the data is automatically written to the table as soon as you enter it on the form.Second thing: Each form needs to be bound to a table, then the controls are bound from there. So just entering Table!field on the data source isn't going to work.If you want to use your 'Submit' button, I would suggest using an unbound form and a bunch of code at the back-end to save it. And it will be more robust than Access data linking. HTH,Tim |
 |
|
|
|
|
|
Contorl Source problem