two forms, same table

[Nathan]

I'll start by explaining what I am trying to accomplish, and work back from
there. Also, I may be posting in the wrong forum, but I couldn't decide
which to use.

I have a "primary" form where the user edits a record. I have a field
(combo box) in this record that is a "rating" for the record (1 - 15). If
the rating 1 is chosen, another combo box is made visible, allowins the user
to choose a "sub-rating" (1 - 5). I have all of this working fine.

The problem is that if the sub-rating 5 is chosen, I THEN want a pop-up form
to appear which allows the user to click on up to four different checkboxes.
All of this is for one record in the same table.

I've gotten this to work, however, I am getting a "Write-Conflict" message.
I need that message to go away. I think I understand why I am getting this -
because of optimistic locking. The main form and the pop-up form are both
getting data from the same record of same table.

So my quandry is HOW to do I accomplish what I am trying to do without
fundamentally changing the structure of my table? I thought about making a
second table just housing the sub ratings with the check boxes, but that
doesn't seem to be correct normalization. Perhaps I'm overthinking it. Any
ideas?

 

[Jeff Boyce]

Nathan

If you are already making a "sub-rating" combobox visible/not, depending on
the first combobox choice, what about the idea of making the set of
checkboxes visible/not, depending on the choice in cbo2? Then you wouldn't
need to create a totally new form.

Good luck!

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.

 

[Nathan]

I thought about that, but I am basically out of real estate. The visual of
the pop-up and the setting the form to modal also was a consideration. if I
can't find any way to make the pop-up work, then I may try it that way.

 

[Jeff Boyce]

Nathan

"real estate" implies that you haven't looked into using the tab control.

Could you 'organize' your data in such a way as to put different
portions/collections on different tabs, then use actions on one tab to force
the focus to another?

(and by the way, making controls appear/disappear can be disconcernting to
users. Consider, instead, using enable/disable, so the users can see that
something can be done, just not under the present circumstances.)

JOPO (just one person's opinions)\

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.

 

[Nathan]

Thanks Jeff, I certainly appreciate the feedback.

Tabs are "off limits" in my organization. There's much history there

 

[Jeff Boyce]

Nathan

OK, so if they can't SEE that they are tabs, does that make a difference?

I created a set of tabs that I use to guide users through a "wizard-like"
progression of screens. I turned OFF the tab that sticks up, and control
movement via events.

It sounds like you are trying to control movement via events too ... would
this approach satisfy the powers? After all, if they can't see them, they
aren't there, right? <g>

Good luck!

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.