How do you add field list to form after form created from query?

B

Bunny

I created a form with a query. The query combined many tables together.
After creating the form, I realized that I need to add two more fields to the
query. Unable to find the two new fields on the field list in form. I when
to the View menu and looked at properties. The Data tab showed the record
source. Somehow I was able to open the Query relationship page and was able
to add the two new fields in the form. However, upong saving the file, the
message "Syntax Error in FORM clause" appeared.

How do I get to see the new field in my field list? How do I resolve the
error message?

Thanks in advance for your help.

Bunny
 
J

John Vinson

Somehow I was able to open the Query relationship page and was able
to add the two new fields in the form. However, upong saving the file, the
message "Syntax Error in FORM clause" appeared.

How do I get to see the new field in my field list?
Click to expand...

Open the Form in design view; view its Properties. On the Data tab
click the ... icon by the Record Source property (the first one); a
query design window will open. Add the two new fields from the table.
Close the window and accept Access' offer to save the SQL.
How do I resolve the error message?
Click to expand...

Correct the query. You've evidently done something to introduce a
syntax error; if you post the SQL code here you'll probably find
someone to help.

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps
 
Top