Data entry attempts cause beep.

[.Len B]

I have a subform whose Record Source is a Select Query. It will not
permit data entry either from the parent form or from the subform itself.
The status bar doesn't give an error message.

AllowAdditions and DataEntry are 'Yes'. Dynaset RecordType, no
RecordLocks. The AllowEdits and AllowDeletions were 'No' but temporarily
changing them to 'Yes' didn't help. Some of the fields are locked but
enabled (eg Date (=Now) and WinUserName) but most are not locked. I have
gone through all the form's properties looking for something without
success.

I can launch the query in the query builder using [...] on RecordSource
item, switch to data view and add new records without issue.

Now I'm asking can anyone point me at somewhere to look, please?

 

[roy]

I have a subform whose Record Source is a Select Query. It will not
permit data entry either from the parent form or from the subform itself.
The status bar doesn't give an error message.

AllowAdditions and DataEntry are 'Yes'. Dynaset RecordType, no
RecordLocks. The AllowEdits and AllowDeletions were 'No' but temporarily
changing them to 'Yes' didn't help. Some of the fields are locked but
enabled (eg Date (=Now) and WinUserName) but most are not locked. I have
gone through all the form's properties looking for something without
success.

I can launch the query in the query builder using [...] on RecordSource
item, switch to data view and add new records without issue.

Now I'm asking can anyone point me at somewhere to look, please?

 

[roy]

(e-mail address removed)...

 

[Gina Whipp]

Len,

You may be able to launch the query but can you edit it? It sounds like you
can't. Fixing the query should fix your issue.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

 

[.Len B]

| I'm not exactly sure what you mean by
|
| "It will not permit data entry either from the parent form or from the
| subform itself."
|
| Can you add/edit data on the main form? If the main form is Read-Only
you
| won't be able to Add/Edit records in the subform.
|
| --
| There's ALWAYS more than one way to skin a cat!
|
| Answers/posts based on Access 2000/2003
|
| Message posted via AccessMonster.com
|
|
What I meant was: When trying to type in any field of the subform, either
by having opened the parent form or just the subform itself, I received a
beep and the cursor didn't move or change.

I then opened the query builder from within the subform as I have said.
I could see the records. I proceeded to the new record row and began
typing dummy data. No objections or beeps and the cursor jumped to
the next field as expected. I didn't try to save the dummy data but I was
allowed to enter it.

I have since had to add fields to underlying tables and I created a new
lookup table as well. I also had to add controls to the subform. That's
when I opened the query from the database window. I removed one join
from the query and added the new one for the lookup.

Now it works. It appears that somehow the join I deleted was making the
data unupdatabe.

Thanks for your help, Linq. I'll keep my eye out for your cat.

 

[.Len B]

I thought so, Gina. I didn't try changing existing data
but it looked like it would let me save new stuff. At least
it let me type stuff and move to the next field.

It doesn't matter now. Users have modified their requirements
and I have changed the query and it now works. See my reply
to Linq.

Thanks for your help. Keep your eye out for Linq's cat too.
You should easily recognize it.
--
Len
______________________________________________________
remove nothing for valid email address.
| Len,
|
| You may be able to launch the query but can you edit it? It sounds
like you
| can't. Fixing the query should fix your issue.
|
| --
| Gina Whipp
|
| "I feel I have been denied critical, need to know, information!" -
Tremors
| II
|
| http://www.regina-whipp.com/index_files/TipList.htm
|
| | >I have a subform whose Record Source is a Select Query. It will not
| > permit data entry either from the parent form or from the subform
itself.
| > The status bar doesn't give an error message.
| >
| > AllowAdditions and DataEntry are 'Yes'. Dynaset RecordType, no
| > RecordLocks. The AllowEdits and AllowDeletions were 'No' but
temporarily
| > changing them to 'Yes' didn't help. Some of the fields are locked but
| > enabled (eg Date (=Now) and WinUserName) but most are not locked. I
have
| > gone through all the form's properties looking for something without
| > success.
| >
| > I can launch the query in the query builder using [...] on
RecordSource
| > item, switch to data view and add new records without issue.
| >
| > Now I'm asking can anyone point me at somewhere to look, please?
| >
| > --
| > Len
| > ______________________________________________________
| > remove nothing for valid email address.
| >
| >
|
|