retrieve table data

[kitaeshi]

Hi all i not very gd in access syntax, hope someone here can guide me.

if i have a table name "fruit", inside have two field "fruitName" & "fruitColor"

if i have a form and there is one textbox inside. wats is the code be to display the "fruitName" onto the texbox. i try [tableName]![fieldName] and it doesn't work


tks for reading

 

[MStef]

1) Open Form in design view.
2) In Form Properties RECORD SOURCE put the name of your table, FRUIT.
3) In Text box properties CONTROL SOURCE put the name of the field from the
table, FRUITNAME.
4) Fill in the Text box properties NAME, with the same as 3) or anything else.