Cannot edit fields on a subform?. It's sending me nuts!

[Guest]

I have a Subform based on a query, which is based on at table. The query
contains a calculated function, for some reason I cannot edit the fields. Can
someome tell me why this may be so?.

everything appears to be in order regarding the various properties relating
to editing.

Data Entry - No
Allow Additions - Yes
Allow Deletetions - Yes
Allow Filters - Yes
Record Locks - No Locks

I'm baffled, and frustrated...

 

[Douglas J. Steele]

If you run the query by itself, is it updatable? If it isn't, the form won't
be either.

 

[Guest]

Douglas,

you may have provided the clue to the problem, but I can't be sure.

The form/Query works like this: it relies on a couple of things.

A criteria on a control that exisits on the form; it is a postcode.
It also relies on a calculated field in the query, that takes two fields
from the base table and calculates the 'GreatDistanceArc' formula against two
fields on the form, which gives me the distance between two geocodes. This
all works fine on the form, but of course when I run the query, the field
results are natrually blank as it doesn't know which postcode control to
reference, and what the equating geocode on the form is. So in summary, the
query returns no results, and only updates when in the form.

Is this the same as your condtional premise of it being updatable?

Here is the SQL:

SELECT tbl_School_Points.KnowledgePointID, tbl_School_Points.Point,
tbl_School_Points.Road_Street, tbl_School_Points.Postcode,
[Forms]![frm_Runs]![Run_From_Lat] AS Lat1, [Forms]![frm_Runs]![Run_From_Lon]
AS Lon1, tbl_School_Points.Lat2, tbl_School_Points.Lon2,
GreatArcDistance([Lat1],[Lon1],[Lat2],[Lon2],3963) AS Dist,
tbl_School_Points.Category
FROM tbl_School_Points
WHERE (((tbl_School_Points.Postcode)=[Forms]![frm_Runs]![Run_From_Postcode]
Or (tbl_School_Points.Postcode)=[Forms]![frm_Runs]![Run_To_Postcode]));

 

[Douglas J. Steele]

While frmRuns is open and has data in the appropriate fields, open the query
up by itself. Can you change data in it?

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

Douglas,

you may have provided the clue to the problem, but I can't be sure.

The form/Query works like this: it relies on a couple of things.

A criteria on a control that exisits on the form; it is a postcode.
It also relies on a calculated field in the query, that takes two fields
from the base table and calculates the 'GreatDistanceArc' formula against
two
fields on the form, which gives me the distance between two geocodes. This
all works fine on the form, but of course when I run the query, the field
results are natrually blank as it doesn't know which postcode control to
reference, and what the equating geocode on the form is. So in summary,
the
query returns no results, and only updates when in the form.

Is this the same as your condtional premise of it being updatable?

Here is the SQL:

SELECT tbl_School_Points.KnowledgePointID, tbl_School_Points.Point,
tbl_School_Points.Road_Street, tbl_School_Points.Postcode,
[Forms]![frm_Runs]![Run_From_Lat] AS Lat1,
[Forms]![frm_Runs]![Run_From_Lon]
AS Lon1, tbl_School_Points.Lat2, tbl_School_Points.Lon2,
GreatArcDistance([Lat1],[Lon1],[Lat2],[Lon2],3963) AS Dist,
tbl_School_Points.Category
FROM tbl_School_Points
WHERE
(((tbl_School_Points.Postcode)=[Forms]![frm_Runs]![Run_From_Postcode]
Or (tbl_School_Points.Postcode)=[Forms]![frm_Runs]![Run_To_Postcode]));

If you run the query by itself, is it updatable? If it isn't, the form
won't
be either.

 

[Guest]

Douglas,

Yes, I can change/ammend data in the query while the form(s) are open. But
when using the form itself, I cannot even get the arrow keys to move through
characters; though I can highlight text with a double-click, and 'cut' with
the right mouse button. But as far as 'standard' editing and controls go,
well... it doesn't.

baffled?...

While frmRuns is open and has data in the appropriate fields, open the query
up by itself. Can you change data in it?

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

Douglas,

you may have provided the clue to the problem, but I can't be sure.

The form/Query works like this: it relies on a couple of things.

A criteria on a control that exisits on the form; it is a postcode.
It also relies on a calculated field in the query, that takes two fields
from the base table and calculates the 'GreatDistanceArc' formula against
two
fields on the form, which gives me the distance between two geocodes. This
all works fine on the form, but of course when I run the query, the field
results are natrually blank as it doesn't know which postcode control to
reference, and what the equating geocode on the form is. So in summary,
the
query returns no results, and only updates when in the form.

Is this the same as your condtional premise of it being updatable?

Here is the SQL:

SELECT tbl_School_Points.KnowledgePointID, tbl_School_Points.Point,
tbl_School_Points.Road_Street, tbl_School_Points.Postcode,
[Forms]![frm_Runs]![Run_From_Lat] AS Lat1,
[Forms]![frm_Runs]![Run_From_Lon]
AS Lon1, tbl_School_Points.Lat2, tbl_School_Points.Lon2,
GreatArcDistance([Lat1],[Lon1],[Lat2],[Lon2],3963) AS Dist,
tbl_School_Points.Category
FROM tbl_School_Points
WHERE
(((tbl_School_Points.Postcode)=[Forms]![frm_Runs]![Run_From_Postcode]
Or (tbl_School_Points.Postcode)=[Forms]![frm_Runs]![Run_To_Postcode]));

If you run the query by itself, is it updatable? If it isn't, the form
won't
be either.

--
Doug Steele, Microsoft Access MVP

(no private e-mails, please)


I have a Subform based on a query, which is based on at table. The query
contains a calculated function, for some reason I cannot edit the
fields.
Can
someome tell me why this may be so?.

everything appears to be in order regarding the various properties
relating
to editing.

Data Entry - No
Allow Additions - Yes
Allow Deletetions - Yes
Allow Filters - Yes
Record Locks - No Locks

I'm baffled, and frustrated...

 

[Douglas J. Steele]

Are the text boxes in the form being used as a subform set to Locked?

Is the subform control itself set to Locked?

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

Douglas,

Yes, I can change/ammend data in the query while the form(s) are open. But
when using the form itself, I cannot even get the arrow keys to move
through
characters; though I can highlight text with a double-click, and 'cut'
with
the right mouse button. But as far as 'standard' editing and controls go,
well... it doesn't.

baffled?...

While frmRuns is open and has data in the appropriate fields, open the
query
up by itself. Can you change data in it?

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

Douglas,

you may have provided the clue to the problem, but I can't be sure.

The form/Query works like this: it relies on a couple of things.

A criteria on a control that exisits on the form; it is a postcode.
It also relies on a calculated field in the query, that takes two
fields
from the base table and calculates the 'GreatDistanceArc' formula
against
two
fields on the form, which gives me the distance between two geocodes.
This
all works fine on the form, but of course when I run the query, the
field
results are natrually blank as it doesn't know which postcode control
to
reference, and what the equating geocode on the form is. So in summary,
the
query returns no results, and only updates when in the form.

Is this the same as your condtional premise of it being updatable?

Here is the SQL:

SELECT tbl_School_Points.KnowledgePointID, tbl_School_Points.Point,
tbl_School_Points.Road_Street, tbl_School_Points.Postcode,
[Forms]![frm_Runs]![Run_From_Lat] AS Lat1,
[Forms]![frm_Runs]![Run_From_Lon]
AS Lon1, tbl_School_Points.Lat2, tbl_School_Points.Lon2,
GreatArcDistance([Lat1],[Lon1],[Lat2],[Lon2],3963) AS Dist,
tbl_School_Points.Category
FROM tbl_School_Points
WHERE
(((tbl_School_Points.Postcode)=[Forms]![frm_Runs]![Run_From_Postcode]
Or (tbl_School_Points.Postcode)=[Forms]![frm_Runs]![Run_To_Postcode]));




:

If you run the query by itself, is it updatable? If it isn't, the form
won't
be either.

--
Doug Steele, Microsoft Access MVP

(no private e-mails, please)


I have a Subform based on a query, which is based on at table. The
query
contains a calculated function, for some reason I cannot edit the
fields.
Can
someome tell me why this may be so?.

everything appears to be in order regarding the various properties
relating
to editing.

Data Entry - No
Allow Additions - Yes
Allow Deletetions - Yes
Allow Filters - Yes
Record Locks - No Locks

I'm baffled, and frustrated...

 

[Guest]

No, all the fields are set to unlocked, same as the form.

Are the text boxes in the form being used as a subform set to Locked?

Is the subform control itself set to Locked?

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

Douglas,

Yes, I can change/ammend data in the query while the form(s) are open. But
when using the form itself, I cannot even get the arrow keys to move
through
characters; though I can highlight text with a double-click, and 'cut'
with
the right mouse button. But as far as 'standard' editing and controls go,
well... it doesn't.

baffled?...

While frmRuns is open and has data in the appropriate fields, open the
query
up by itself. Can you change data in it?

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)



Douglas,

you may have provided the clue to the problem, but I can't be sure.

The form/Query works like this: it relies on a couple of things.

A criteria on a control that exisits on the form; it is a postcode.
It also relies on a calculated field in the query, that takes two
fields
from the base table and calculates the 'GreatDistanceArc' formula
against
two
fields on the form, which gives me the distance between two geocodes.
This
all works fine on the form, but of course when I run the query, the
field
results are natrually blank as it doesn't know which postcode control
to
reference, and what the equating geocode on the form is. So in summary,
the
query returns no results, and only updates when in the form.

Is this the same as your condtional premise of it being updatable?

Here is the SQL:

SELECT tbl_School_Points.KnowledgePointID, tbl_School_Points.Point,
tbl_School_Points.Road_Street, tbl_School_Points.Postcode,
[Forms]![frm_Runs]![Run_From_Lat] AS Lat1,
[Forms]![frm_Runs]![Run_From_Lon]
AS Lon1, tbl_School_Points.Lat2, tbl_School_Points.Lon2,
GreatArcDistance([Lat1],[Lon1],[Lat2],[Lon2],3963) AS Dist,
tbl_School_Points.Category
FROM tbl_School_Points
WHERE
(((tbl_School_Points.Postcode)=[Forms]![frm_Runs]![Run_From_Postcode]
Or (tbl_School_Points.Postcode)=[Forms]![frm_Runs]![Run_To_Postcode]));




:

If you run the query by itself, is it updatable? If it isn't, the form
won't
be either.

--
Doug Steele, Microsoft Access MVP

(no private e-mails, please)


I have a Subform based on a query, which is based on at table. The
query
contains a calculated function, for some reason I cannot edit the
fields.
Can
someome tell me why this may be so?.

everything appears to be in order regarding the various properties
relating
to editing.

Data Entry - No
Allow Additions - Yes
Allow Deletetions - Yes
Allow Filters - Yes
Record Locks - No Locks

I'm baffled, and frustrated...

 

[Douglas J. Steele]

I'm sorry: I'm out of ideas.

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

No, all the fields are set to unlocked, same as the form.

Are the text boxes in the form being used as a subform set to Locked?

Is the subform control itself set to Locked?

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

Douglas,

Yes, I can change/ammend data in the query while the form(s) are open.
But
when using the form itself, I cannot even get the arrow keys to move
through
characters; though I can highlight text with a double-click, and 'cut'
with
the right mouse button. But as far as 'standard' editing and controls
go,
well... it doesn't.

baffled?...



:

While frmRuns is open and has data in the appropriate fields, open the
query
up by itself. Can you change data in it?

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)



Douglas,

you may have provided the clue to the problem, but I can't be sure.

The form/Query works like this: it relies on a couple of things.

A criteria on a control that exisits on the form; it is a postcode.
It also relies on a calculated field in the query, that takes two
fields
from the base table and calculates the 'GreatDistanceArc' formula
against
two
fields on the form, which gives me the distance between two
geocodes.
This
all works fine on the form, but of course when I run the query, the
field
results are natrually blank as it doesn't know which postcode
control
to
reference, and what the equating geocode on the form is. So in
summary,
the
query returns no results, and only updates when in the form.

Is this the same as your condtional premise of it being updatable?

Here is the SQL:

SELECT tbl_School_Points.KnowledgePointID, tbl_School_Points.Point,
tbl_School_Points.Road_Street, tbl_School_Points.Postcode,
[Forms]![frm_Runs]![Run_From_Lat] AS Lat1,
[Forms]![frm_Runs]![Run_From_Lon]
AS Lon1, tbl_School_Points.Lat2, tbl_School_Points.Lon2,
GreatArcDistance([Lat1],[Lon1],[Lat2],[Lon2],3963) AS Dist,
tbl_School_Points.Category
FROM tbl_School_Points
WHERE
(((tbl_School_Points.Postcode)=[Forms]![frm_Runs]![Run_From_Postcode]
Or
(tbl_School_Points.Postcode)=[Forms]![frm_Runs]![Run_To_Postcode]));




:

If you run the query by itself, is it updatable? If it isn't, the
form
won't
be either.

--
Doug Steele, Microsoft Access MVP

(no private e-mails, please)


I have a Subform based on a query, which is based on at table. The
query
contains a calculated function, for some reason I cannot edit the
fields.
Can
someome tell me why this may be so?.

everything appears to be in order regarding the various
properties
relating
to editing.

Data Entry - No
Allow Additions - Yes
Allow Deletetions - Yes
Allow Filters - Yes
Record Locks - No Locks

I'm baffled, and frustrated...

 

[Guest]

Ok, thanks for trying. appreciated.

one loast thing though, here is part of the 'documenter' for the form. if
you look, you will see this entry; AllowUpdating: No

is that releveant, and where is the swithc for that?


Properties
AllowAdditions: True AllowDatasheetView: True
AllowDeletions: True AllowDesignChanges: True
AllowEditing: True AllowEdits: True
AllowFilters: True AllowFormView: True
AllowLayoutView: True AllowPivotChartView: False
AllowPivotTableView: False AllowUpdating: No
AutoCenter: True AutoResize: True
BorderStyle: Sizable Caption: frm_#QRY_Gecode_School_
Points subform
CloseButton: True Container: Forms
ControlBox: True Count: 22
CurrentView: 0 Cycle: All Records
DataEntry: False DatasheetAlternateBackCol 16053492
DatasheetBackColor: 16777215 DatasheetBorderLineStyle: 1
DatasheetCellsEffect: Flat DatasheetColumnHeaderU 1
DatasheetFontHeight: 9 DatasheetFontItalic: False
DatasheetFontName: Calibri DatasheetFontUnderline: False
DatasheetFontWeight: Normal DatasheetForeColor: 0
DatasheetGridlinesBehavior Both DatasheetGridlinesColor: 15062992
DateCreated: 29/10/2007 01:20:41 DefaultEditing: 2
DefaultView: Continuous Forms DisplayOnSharePointSite: Follow Table Setting
DividingLines: False FastLaserPrinting: True
FetchDefaults: True FilterOn: False
FilterOnLoad: False FitToScreen: True
FrozenColumns: 1 GridX: 10

I'm sorry: I'm out of ideas.

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

No, all the fields are set to unlocked, same as the form.

Are the text boxes in the form being used as a subform set to Locked?

Is the subform control itself set to Locked?

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)


Douglas,

Yes, I can change/ammend data in the query while the form(s) are open.
But
when using the form itself, I cannot even get the arrow keys to move
through
characters; though I can highlight text with a double-click, and 'cut'
with
the right mouse button. But as far as 'standard' editing and controls
go,
well... it doesn't.

baffled?...



:

While frmRuns is open and has data in the appropriate fields, open the
query
up by itself. Can you change data in it?

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)



Douglas,

you may have provided the clue to the problem, but I can't be sure.

The form/Query works like this: it relies on a couple of things.

A criteria on a control that exisits on the form; it is a postcode.
It also relies on a calculated field in the query, that takes two
fields
from the base table and calculates the 'GreatDistanceArc' formula
against
two
fields on the form, which gives me the distance between two
geocodes.
This
all works fine on the form, but of course when I run the query, the
field
results are natrually blank as it doesn't know which postcode
control
to
reference, and what the equating geocode on the form is. So in
summary,
the
query returns no results, and only updates when in the form.

Is this the same as your condtional premise of it being updatable?

Here is the SQL:

SELECT tbl_School_Points.KnowledgePointID, tbl_School_Points.Point,
tbl_School_Points.Road_Street, tbl_School_Points.Postcode,
[Forms]![frm_Runs]![Run_From_Lat] AS Lat1,
[Forms]![frm_Runs]![Run_From_Lon]
AS Lon1, tbl_School_Points.Lat2, tbl_School_Points.Lon2,
GreatArcDistance([Lat1],[Lon1],[Lat2],[Lon2],3963) AS Dist,
tbl_School_Points.Category
FROM tbl_School_Points
WHERE
(((tbl_School_Points.Postcode)=[Forms]![frm_Runs]![Run_From_Postcode]
Or
(tbl_School_Points.Postcode)=[Forms]![frm_Runs]![Run_To_Postcode]));




:

If you run the query by itself, is it updatable? If it isn't, the
form
won't
be either.

--
Doug Steele, Microsoft Access MVP

(no private e-mails, please)


I have a Subform based on a query, which is based on at table. The
query
contains a calculated function, for some reason I cannot edit the
fields.
Can
someome tell me why this may be so?.

everything appears to be in order regarding the various
properties
relating
to editing.

Data Entry - No
Allow Additions - Yes
Allow Deletetions - Yes
Allow Filters - Yes
Record Locks - No Locks

I'm baffled, and frustrated...