Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Simple question on forms

Status
Not open for further replies.

choppysuey

Technical User
Mar 28, 2001
54
US
I'm brand new to access and have a question about building forms. How do I add a field list to a form if the form is already created without one? (i.e. built from 'create form in design view' link) I've tried setting the control source on a text field to a table and field like so:
[orders]![orderid] and it still doesn't work.
 
You have to set the Record Source for the form; not the control source on individual fields.

1.Place the form in design view.

2.double-click the gray box intersecting the vertical and horizontal rulers (upper left corner).

3.On the Data tab, set the Record Source to the desired table/query.
 
duh...I feel so lame. Brain fart. Thx for the reply. =)
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top