Form fields won't show? ;-(

[misscrf]

I know this is a wierd question. I have an Access FE with a SQL BE. I updated a form on the front end with a new table and new fields, removing the old fields. I have linked in the new table, and set that as the source for the form. I added the new fields to the form, but now when I put the form in preview mode, I see no fields. They are all set to visible can grow and can shrink. The form is set to visible. It is a subform, and I tested opening it separately. The fields are not visible then either.

I have switched the view to datasheet, and I can see the column headings then, but no ability to add a record. I added my AD account to the SQL security as an admin for the entire sql server. I cannot seem to figure out why I cant see these fields, or make a new record.

Any thoughts? Has anyone seen this before?

misscrf

It is never too late to become what you could have been ~ George Eliot

 

[Golom]

Does your table have a primary key defined?

 

[TheAceMan1]

How are ya misscrf . . .

[ol][li]Can you see the data in the new table?[/li]
[li]If you can see the data in the table, make a quick query and verify you get data![/li]
[li]I have to believe spelling is ok . . . Yes?[/li][/ol]

See Ya! . . . . . .

Be sure to see thread181-473997
Also faq181-2886

 

[misscrf]

Thank you both for responding. The cupie doll goes to Golom. I hadn't defined a primary key.

misscrf

It is never too late to become what you could have been ~ George Eliot