Query based Subform will not allow editing

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a maintenance DB that has energy lockout points associated with pieces
of equipment so we can safely do maintenance.

I have an 'edit existing lockout' form, based on a query, that lists in a
subform the various points required for a certain piece of equipment.

My system used to work, but now I can edit the main, but the subform has
locked me out. All I get is a doorbell tone when I attempt to enter info. I
can enter the req'd info in the tables, but but my form went snafu.

Any ideas? Thanks in advance
 
Does your query allow editing? Check the asterisk in the record navigation
at the bottom to see if it's enabled. If not, your query is not editable,
you may need the primary key in the query to make it editable.
 
This doesn't seem to work. The * shows in the bottom line until I enter a
cell then it turns to an arrowhead and I get the doorbell tone. The query
subdatasheet is noted in the main query properties, the key is in the query,
....

Also does anyone know why my query parameter ctriertion loses it's minf ecah
time I edit the query? I now retype the criteria each time I edit to try
something new.

Thanks
 
Maintenance man said:
This doesn't seem to work. The * shows in the bottom line until I enter a
cell then it turns to an arrowhead and I get the doorbell tone. The query
subdatasheet is noted in the main query properties, the key is in the query,
...

Also does anyone know why my query parameter criterion loses it's mind each
time I edit the query? I now retype the criteria each time I edit to try
something new.

Thanks
Click to expand...
 
It's not bad typing either:) ... edited for typos, I should have said, "Also
does anyone know why my query parameter criterion loses it's mind each time I
edit the query? I now retype the criteria each time I edit to try something
new.
 
Back
Top