Field visibility on a form

Danny

Registered User.
Local time
Today, 16:01
Joined
Jul 31, 2002
Messages
147
Hi,

I created few new fields and change the labels for some of the existing fields. When I access the back end, I can see records users already inputted. When I create a query, I can see the data that was entered. But, for some reason it is invisible on the form ie. the form shows blank. Attached is a screenshot.


I checked the fields property and verified enabled is set to Yes.
TIA

Regards,
 

Attachments

  • Screenshot .jpg
    Screenshot .jpg
    114.6 KB · Views: 30
Check the form's data properties. Data Entry should be set to "No". Setting it to "Yes" allows you to enter new data without viewing existing data. If this doesn't match your situation, you might want to view other data properties including the Record Source.
1754801735511.png
 
Just to cover other bases, I would also check the controlsource of the controls are specified
 
Has the form by any chance been opened with the acFormAdd constant as the DataMode arrgument? e.g.

Code:
DoCmd.OpenForm "frmEmployeeList", DataMode:=acFormAdd
 
Thank you for your feedbacks.
Has the form by any chance been opened with the acFormAdd constant as the DataMode arrgument?
The form itself is not new. I just added few fields to an existing form that was working fine. However, the record added to the new fields, are not visible. But, when I run queries, I can see the newly added data on the result. I’ll check what you suggested when I get to work.


TIA

Regards,
 
The form itself is not new. I just added few fields to an existing form that was working fine. However, the record added to the new fields, are not visible. But, when I run queries, I can see the newly added data on the result.

Make sure that the fields are returned by the form's RecordSource, and that the control's you've added to the form have their ControlSource property each set to the correct field name.
 

Users who are viewing this thread

Back
Top Bottom