Access Native Query vs sql View (1 Viewer)

[oleronesoftwares]

what do you put in the controlsource

nothing

 

[CJ_London]

so users are never editing data since there is nothing for them to edit?

Suggest provide a working example of what you mean

 

[oleronesoftwares]

so users are never editing data since there is nothing for them to edit?

Buttons and vba code to load data(select query) or insert records

 

[CJ_London]

still don't see it. I asked if you populated the controlsource with a field name or a value, You said you don't populate the controlsource at all - so agreed it is unbound. I'm asking how does a user edit data? - they click the load button - what does the code behind the button actually do?

 

[oleronesoftwares]

what does the code behind the button actually do?

The load button code behind- is a select statement that populates the controls with values and makes the form editable

The insert button- code-behind only inserts values.

This approach has always been in ms access but rarely used by developers because it's time-consuming.

Hope that explains it better, but as some others have advised using bound control can work in this scenario, so it's left to the OP whether to use linked tables or query.

 

[CJ_London]

Ok - so only works for single forms then, thanks for the clearer explanation