|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
October 19th, 2005, 08:16 PM
|
|||
|
|||
Record source help
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? 
|
|
#2
October 19th, 2005, 09:49 PM
|
|||
|
|||
|
Record source help
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 "tcorlew" wrote: 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?
|
|
#3
October 19th, 2005, 10:00 PM
|
|||
|
|||
|
Record source help
I figured out what I did....Thanks anyway.
"Sprinks" wrote: 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 "tcorlew" wrote: 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?
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Record source selector... | postman | Running & Setting Up Queries | 1 | May 14th, 2005 12:09 PM |
| Changing Record Source and Subform Disapears | Joe Gieder | Using Forms | 6 | March 30th, 2005 09:01 PM |
| Setting sub report Record Source | gr | Setting Up & Running Reports | 1 | July 21st, 2004 05:41 PM |
| filter adp report where record source uses aggregate functions | eddiec | General Discussion | 6 | July 12th, 2004 07:48 AM |
| Changing record source in a report | MJJ | Setting Up & Running Reports | 1 | June 6th, 2004 08:47 PM |
Linear Mode
