Linking forms field and table field .

  • Thread starter Thread starter aligahk06
  • Start date Start date
A

aligahk06

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
 
aligahk06,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)
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."
 
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,
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."
 
Back
Top