• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 382
  • Last Modified:

Expression builder in access 2007

hi i have a db with a table named NotesTable and 1 field in that table called Notes....pretty simple

i have a form called ProF and it's control source is a different table
i want to put a text box on the ProF form that is linked to the Notes field in NotesTable while all the other controls on that form pull data from the other table

i went into expression builder and entered [NotesTable]![Notes] as the control source but i must be missing some syntax because it doesn't work

can someone steer me in the right direction?


  • 2
2 Solutions
It doesn't work because you can't do that.

To get data from a different table to the recordsource you can use a Dlookup() function.

How do you know which record to get the data from in NotesTable?
RunToTheHillsAuthor Commented:
NotesTable has just 1 field "Notes", I want the text box on the form to be able to write a new record to the field and also navigate thru all the records in that Notes field

i'll do some googling on Dlookup and any other help you can give i will appreciate

You can bind your form1 to table1, and on form1 create a cboNotes combobox that derives its contents from Notestable.  In the design view, insert a combobox, rightclick, select properties, data tab, table/query type -table/query, in table/query:

SELECT NotesTable.Notes from NotesTable;

set bound column 1

select format tab

number columns 1

column widths - what ever you need in inches.
Just curious, combo or DLookup?
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now