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