If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Linking forms field and table field .
Dear All,
I have a form but i could not move to the next record and even i could n't save the records to the table. How can a table and a form fields can be linked.I'm encountering #Name error. Can anybody look out the form and advise me. Help is deeply welcome. Rgds, Aligahk06 |
#2
|
|||
|
|||
Linking forms field and table field .
aligahk06,
How can a table and a form fields can be linked. A form can have, as it's RecordSource, a table, or a query Most times, it's a query. Place your cursor in your form's RecordSource textbox, and click the arrow that appears on the right. Using this query grid set up the table and fields for the query that will be delivered to the form. The data controls on your form will each be bound to one of those fields from that query (using the Field List) I'm encountering #Name error. On your form, one of the controls is bound to a field that Access can not find. For example if you have a field in your table named ItemPrice, but on the form, one of your controls ControlSource is set to Contol Name: ItemRetailPrice ControlSource: ItemPricce (misspelled) will cause a #Name error. Also, any calculated text control, that references a table field incorrectly, or the name of a control on the form incorrectly... = ItemRetaiPrice * 10 (misspelled) will cause a #Name error. -- hth Al Campagna Microsoft Access MVP 2007-2009 http://home.comcast.net/~cccsolutions/index.html "Find a job that you love... and you'll never work a day in your life." "aligahk06" wrote in message ... Dear All, I have a form but i could not move to the next record and even i could n't save the records to the table. How can a table and a form fields can be linked.I'm encountering #Name error. Can anybody look out the form and advise me. Help is deeply welcome. Rgds, Aligahk06 |
#3
|
|||
|
|||
Linking forms field and table field .
i have lots of problem too yousing this e amil pleas send one e amil to may
acount and let me no how i fin and do things so i can sending mails pleas "aligahk06" skrev i melding ... Dear All, I have a form but i could not move to the next record and even i could n't save the records to the table. How can a table and a form fields can be linked.I'm encountering #Name error. Can anybody look out the form and advise me. Help is deeply welcome. Rgds, Aligahk06 |
#4
|
|||
|
|||
Linking forms field and table field .
Aligahk06,
Sorry, but responders are generally respond within these newgroups. If your uncertain about how to ask questions, read responses, and reply to newsgroups, try using Google groups. Find the microsoft.public.access.gettingstarted group and use that to continue with your original post. You can find your post, read our responses, and respond back... all without using an email program. -- hth Al Campagna Microsoft Access MVP 2007-2009 http://home.comcast.net/~cccsolutions/index.html "Find a job that you love... and you'll never work a day in your life." "Sanne" wrote in message ... i have lots of problem too yousing this e amil pleas send one e amil to may acount and let me no how i fin and do things so i can sending mails pleas "aligahk06" skrev i melding ... Dear All, I have a form but i could not move to the next record and even i could n't save the records to the table. How can a table and a form fields can be linked.I'm encountering #Name error. Can anybody look out the form and advise me. Help is deeply welcome. Rgds, Aligahk06 |
Thread Tools | |
Display Modes | |
|
|