Record source help

T

tcorlew

HELP!
After I added a field to one of my tables it wouldn't show up in my field
list so I went to properties-recordsource and manually keyed it in. At first
it seemed to work and the new field was displayed but as soon as I saved the
table it gave me the message of "cannot open anymore tables."

Anyone know how to fix this?
 
S

Sprinks

I don't follow what you did to the RecordSource property, but the usual
reason you can't an added field is that the RecordSource of your form is set
to a named query rather than the table itself. If this is the case, you must
add the field to the query as well.

Hope that helps.
Sprinks
 
T

tcorlew

I figured out what I did....Thanks anyway.

Sprinks said:
I don't follow what you did to the RecordSource property, but the usual
reason you can't an added field is that the RecordSource of your form is set
to a named query rather than the table itself. If this is the case, you must
add the field to the query as well.

Hope that helps.
Sprinks
Click to expand...
 
Top