Locked(?) or disabled(?) unable to enter data.

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Chris - 14 Jul 2007 22:28 GMT

I am not a pro...hoping you can provide help.

My client entry form has a jobs subform and jobs has a details subform. All
are set to data entry either by property or code.

As I enter data, if I do so in order of parent, sub1, and sub2 I get no
surprises. However, when I want to return to either the parent or sub1 to
change an entry or make one that was missed, the control (on only parent or
sub1) are locked. At least I think locked, they appear to be enabled - no
change in appearance.

Can anyone point to where I could look for resolution?

Signature

Thanks for your help,
Chris

Reply to this Message

ruralguy - 14 Jul 2007 23:49 GMT

If it helps you, when you move from MainForm to SubForm or SubForm to SubForm,
the form you are leaving has the current record saved. Since you said you
have DataEntry turned on and that only allows viewing of new, unsaved records,
that is where I would begin looking for the problem.

>I am not a pro...hoping you can provide help.
>
[quoted text clipped - 8 lines]
>
>Can anyone point to where I could look for resolution?

Signature

HTH - RuralGuy (RG for short) acXP WinXP Pro
Please post back to this forum so all may benefit.

Reply to this Message

Chris - 15 Jul 2007 00:36 GMT

Thanks for the reply RG.

I think I should have stated:

Parent has several subforms on tabs.
One of the parent's subforms has several subforms (no tabs).

I can make entry on parent and any subform1 and return to parent OK>
I can make entry on any subform1 then any other subform1 or parent and
return to either OK.

What I cannot do is return anywhere other than subform2 after making entry
on subform2.

I suspect my problem is property or code for subform2, but can't see it.

What do you think now?

Signature

Thanks for your help,
Chris

> If it helps you, when you move from MainForm to SubForm or SubForm to SubForm,
> the form you are leaving has the current record saved. Since you said you
[quoted text clipped - 13 lines]
> >
> >Can anyone point to where I could look for resolution?

Reply to this Message

ruralguy - 15 Jul 2007 03:08 GMT

I take it subform2 is a SubForm of subform1? What are you using for the
LinkChild/MasterFields for these forms?

>Thanks for the reply RG.
>
[quoted text clipped - 18 lines]
>> >
>> >Can anyone point to where I could look for resolution?

Signature

HTH - RuralGuy (RG for short) acXP WinXP Pro
Please post back to this forum so all may benefit.

Reply to this Message

Chris - 15 Jul 2007 03:46 GMT

You are correct, sir.

Client-subform1 (each subform1 uses ClientID the key field)
Subform1-Subform2 (each Subform2 uses InvNum the key field.

Recall that only one of several Subforms1 has subforms2.
On that single subform1, InvNum is a control.

--
Thanks for your help,
Chris

> I take it subform2 is a SubForm of subform1? What are you using for the
> LinkChild/MasterFields for these forms?
[quoted text clipped - 21 lines]
> >> >
> >> >Can anyone point to where I could look for resolution?

Reply to this Message

ruralguy - 15 Jul 2007 04:06 GMT

I would open a code window and go to Tools>Options...>General tab and set
your system to "Break on All Errors" and then run your system. See if there
is an error being thrown that is covered up some how.

>You are correct, sir.
>
[quoted text clipped - 9 lines]
>> >> >
>> >> >Can anyone point to where I could look for resolution?

Signature

HTH - RuralGuy (RG for short) acXP WinXP Pro
Please post back to this forum so all may benefit.

Reply to this Message

Chris - 15 Jul 2007 17:44 GMT

Thanks...I found the problem. I had a subform set to record lock. Duh! I
guess I shoulda looked there first.

Anyway, thanks -- you did point the way for me.

Signature

Thanks for your help,
Chris

> I would open a code window and go to Tools>Options...>General tab and set
> your system to "Break on All Errors" and then run your system. See if there
[quoted text clipped - 13 lines]
> >> >> >
> >> >> >Can anyone point to where I could look for resolution?

Reply to this Message

ruralguy - 15 Jul 2007 18:11 GMT

Glad to hear you got it sorted.

>Thanks...I found the problem. I had a subform set to record lock. Duh! I
>guess I shoulda looked there first.
[quoted text clipped - 5 lines]
>> >> >> >
>> >> >> >Can anyone point to where I could look for resolution?

Signature

HTH - RuralGuy (RG for short) acXP WinXP Pro
Please post back to this forum so all may benefit.

Reply to this Message