I need the minimum value among 5 different fields in one record

I have used the "fixed" subform concept that Maj showed. If you decide to add the fixed current list when a new quote is requested, you can set the subform to not allow adds or deletes and to not show scroll bars. This requires no extra coding and allows the subform to be completely "hidden" but if you need to increase from 5 to 6, you need to futz with the size of the subform and that's it. Always embed a note to self in the code when you do something like this so you never forget why you needed to do this and also add comments regarding what needs to change if the number of quoters needs to grow.
 
I really like this approach. Can you explain how you did it
Just formatting.
Scroll bars - None
Record Selectors and Navigation bar - no
Name Field - locked and no tab stop. Might be disabled
Subform - Transparent border
Subform back color - same as main form

This will work fine if you do not have variable amounts of quote. In my example I allow you to modify and add additional quotes. Without scroll bars that would be hard to navigate and even know that there are additional ones, if it is beyond the size of the subform control. You could make the subform control a little larger and you would not know.
Or you could move it right a little and make it as big as you want and still put some fields below.
 
Form Aesthetics is not my strong suit, but I will say your example is just painful to look at. I would hate entering info into that.
With a little formatting and organizing you could make that nicer. Again this is not my strong suit there are people who can make really nice looking forms.
But I would do it more like this to allow me the option of adding additional quotes. This gives me some real estate to make the subform bigger than required.
Here is with the baseline 5. (Now that I count it is with six)
5.PNG


But if I need to add additional quotes the functionality is there.
formMany.PNG

That is nine so you can make the quote "frame" smaller if you think the absolute max is 6,7,8..
Also I would format "Company Name" different so it does not blend into the actual company names. Maybe underline or different color.
 

Attachments

Last edited:

Users who are viewing this thread

Back
Top Bottom