Field visibility on a form (1 Viewer)

[Danny]

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,

 

[DHookom]

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.

 

[CJ_London]

Just to cover other bases, I would also check the controlsource of the controls are specified

 

[Ken Sheridan]

Has the form by any chance been opened with the acFormAdd constant as the DataMode arrgument? e.g.

DoCmd.OpenForm "frmEmployeeList", DataMode:=acFormAdd

 

[Danny]

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,

 

[Ken Sheridan]

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.

 

[Danny]

Ken,
Thanks, I sure will check and post back the result.

Regards,

 

[Gasman]

Can you see that data in qryEmployees?
Did you amend that query for the new fields?

How is data getting into those fields anyway?

 

[Danny]

Gasman thanks.

Can you see that data in qryEmployees?

The name of my table/form actually is Financial. I think DHookom used Northwind Employees as an example. But, to answer your question yes, I see the data in qryFinancial

How is data getting into those fields anyway?

Users input the data via form financial. I also entered the data in the backend.

Did you amend that query for the new fields?

No, I did not. I'm not sure how to go about doing this. Maybe this is the issue.

TIA

Regards,

 

[The_Doc_Man]

If your query drives the form and the query doesn't contain the fields, neither will the form.

If that is a stored query, you can amend it by opening it in design mode. In that mode you have the option to show all fields available to you from that table, each one suitable for adding to the query. It might be as simple as dragging and dropping the new fields from the table, one for each action, to the query grid at the next blank column to the immediate right of the last populated column. That puts the named fields into the query. Then the .ControlSource of each new control could be edited to the name of one of the added fields.

If I understood your description, perhaps that will help you. If I misunderstood and it confuses you, sorry!

 

[Gasman]

Gasman thanks.

The name of my table/form actually is Financial. I think DHookom used Northwind Employees as an example. But, to answer your question yes, I see the data in qryFinancial


Users input the data via form financial. I also entered the data in the backend.


No, I did not. I'm not sure how to go about doing this. Maybe this is the issue.

TIA

Regards,

Ah apologies, but the logic still applies.
If you can see that new data in qryFinancial, then you have added the new fields.
Now in your form, do the new controls have those exact named fields as their control source?

Failing that, can you upload enough to see the issue?
If data is confidential then you can use this to change it on the new DB.
We only need enough to see the issue, that is all.

Users input the data via form financial. I also entered the data in the backend.

I can understand data being entered directly into the BE, though not recommended.
If they are using the form to enter data, then that data must be visible? UNLESS as mentioned, you have the form in Data Entry mode?

That is the most misnamed property in Access. It only allows data to be added (not edited/deleted). I myself have never had to use it. I have always used full add/edit/delete operations on any form.