Need Drop-Down Menu to auto-fill 2 unbound boxes (1 Viewer)

henryihunter1954

Registered User.
Local time
Today, 06:37
Joined
Mar 2, 2016
Messages
89
First, thank everyone for previous assistance. You all are really fantastic.

Second, hope everyone has enjoyed the holidays. Peace and Love.


I have a situation with a Subform that has 2 drop-down menus.
The first drop-down selects a product from a list.
The 2nd drop down displays a listing of Prices and 2 field sizes:
[Price - $1,000] [Die - 3 X 6 X 8] [Base - 4 x 1 x 6] Examples

In this drop-down list, the Product Price list may have 1-4 different options to choose from.
At this time, I have success with selecting the Price (any one of the 1-4 options). The problem is getting the Die and Base options to fill in with anything. The 2 unbound fields , which I would hope, would be filled in by the selection of the correct price. Not working for me.

Note: I am also using a Line total layout in the subform to display the data that I've discussed above.

Thanking you all in advance for any suggestions to resolve the above issue.

Again...Hope you all are having a very joyous holiday.
 

henryihunter1954

Registered User.
Local time
Today, 06:37
Joined
Mar 2, 2016
Messages
89
Uncle Gizmo,

This is exactly what I needed to get the job done.
I'd gone into YouTube and seen a video similar and I could not remember how to do the setting of the 2 unbound boxes to the columns.
I could not remember the video nor the correct code for identifying the Column.
(I'm getting old)
I downloaded the video and I will follow the instructions.

Sir, thank you so very much for the quick response and the great guide you suggested for me to follow.
So far, the assistance with this group of professionals is really great.

Thank you again and I hope all is well for you during this time of year.
Be blessed.
 

Uncle Gizmo

Nifty Access Guy
Staff member
Local time
Today, 13:37
Joined
Jul 9, 2003
Messages
16,245
Uncle Gizmo,

This is exactly what I needed to get the job done.
I'd gone into YouTube and seen a video similar and I could not remember how to do the setting of the 2 unbound boxes to the columns.
I could not remember the video nor the correct code for identifying the Column.
(I'm getting old)
I downloaded the video and I will follow the instructions.

Sir, thank you so very much for the quick response and the great guide you suggested for me to follow.
So far, the assistance with this group of professionals is really great.

Thank you again and I hope all is well for you during this time of year.
Be blessed.

Thank you very much! Just to be clear, I did the video and all of the other videos on that YouTube channel. You could do me a big favour by subscribing to my YouTube channel:-

https://www.youtube.com/user/UncleGizmo?sub_confirmation=1

Merry Christmas!



Sent from my SM-G925F using Tapatalk
 

henryihunter1954

Registered User.
Local time
Today, 06:37
Joined
Mar 2, 2016
Messages
89
Uncle Gizmo:

I tried it and it worked like a Magical Charm....
Thank you so much.

I also read about subscribing to your channel.
(I subscribed)
Thank you again and Merry Christmas
 

mqnf

New member
Local time
Today, 06:37
Joined
Jan 3, 2019
Messages
4
This is all very useful, thank you! I am trying to apply the method to a similar application. What if you wanted the unbound textbox to display a previously saved message (i.e. helpfile), whenever the checkbox was checked; and again hide the helpfile whenever the checkbox is unchecked?

This code is returning an error, stating invalid outside procedure due to either a result of the name of the macro (unused), name of the user-defined function (unsure), or Event Procedure (I'm using event procedure).

The checkbox name is "cbCrackingMajor" and textbox name is tbCrackingMajor".
Here is the VB being used:

Private Sub cbCrackingMajor_Click()
If Me.cbCrackingMajor = -1 Then
Me.tbCrackingMajor.Visible = True
Else
Me.tbCrackingMajor.Visible = False
Me.cbCrackingMajor.Value = Null
End If

Private Sub Other_AfterUpdate()
If Me.cbCrackingMajor = -1 Then
Me.tbCrackingMajor.Visible = True
Else
Me.tbCrackingMajor.Visible = False
Me.cbCrackingMajor.Value = Null
End If

End Sub


** You'll note I haven't even referenced the helpfile yet, because testing of the show/hide textbox is failing... **
 

Users who are viewing this thread

Top Bottom