Record source help

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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
 
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...
 
Back
Top