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
|
|||
|
|||
I cant see my fields in form view.
Created a subform on a tab. When I change back to form view the fields do
not appear. It is a blank box. |
#2
|
|||
|
|||
I cant see my fields in form view.
Kaitl,
Check the RecordSOurce for you subform it could be that it's not returning an records OR you have set the Data Entry to Yes and you can't see the old records. -- Gina Whipp 2010 Microsoft MVP (Access) "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "kaitl" wrote in message ... Created a subform on a tab. When I change back to form view the fields do not appear. It is a blank box. |
#3
|
|||
|
|||
I cant see my fields in form view.
On Thu, 21 Jan 2010 16:18:01 -0800, kaitl
wrote: Created a subform on a tab. When I change back to form view the fields do not appear. It is a blank box. This will happen when two conditions apply: the form's Recordsource returns no records (so you can't see existing records), and it's not updateable (so you can't see the blank new record either). What is the Recordsource property of the subform? Post the SQL. If you open it as a query datasheet, is there a * "new record" line at the bottom? (I'm betting there isn't). -- John W. Vinson [MVP] |
#4
|
|||
|
|||
I cant see my fields in form view.
John,
Okay, you did say it better then I did... g -- Gina Whipp 2010 Microsoft MVP (Access) "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "John W. Vinson" wrote in message news On Thu, 21 Jan 2010 16:18:01 -0800, kaitl wrote: Created a subform on a tab. When I change back to form view the fields do not appear. It is a blank box. This will happen when two conditions apply: the form's Recordsource returns no records (so you can't see existing records), and it's not updateable (so you can't see the blank new record either). What is the Recordsource property of the subform? Post the SQL. If you open it as a query datasheet, is there a * "new record" line at the bottom? (I'm betting there isn't). -- John W. Vinson [MVP] |
#5
|
|||
|
|||
I cant see my fields in form view.
John W. Vinson wrote in
news This will happen when two conditions apply: the form's Recordsource returns no records (so you can't see existing records), and it's not updateable (so you can't see the blank new record either). Updatability is not the sole issue, but "Addability". That is, AllowEdits has to be on (as well as AllowEdits). -- David W. Fenton http://www.dfenton.com/ usenet at dfenton dot com http://www.dfenton.com/DFA/ |
#6
|
|||
|
|||
I cant see my fields in form view.
On 22 Jan 2010 22:19:18 GMT, "David W. Fenton"
wrote: Updatability is not the sole issue, but "Addability". That is, AllowEdits has to be on (as well as AllowEdits). I'm sure David meant AllowAdditions. -- John W. Vinson [MVP] |
Thread Tools | |
Display Modes | |
|
|