Feel dumb for having to ask...

M

Marcus Finch

Okay, so I have a set of forms that are unnecessarily complicated,
referencing other forms and a dozen other things that are just a royal
pain, but my current frustration is selecting a specific value from
the list of a combobox on load. I need the user to be able to change
the value -after- the form loads, but at first that box needs to be
selected and displaying records.

It will be referencing a value on another form that will stay open
behind it to get its own value. Also, the displayed value is not
going to be the data that's passed from the other form because that
data is not necessarily unique, the other forms combobox we're pulling
from has a bound column for the UID and then a display for the user
friendly value which is exactly what I need on this one as well, just
need it autoselected. Any help you can offer would be appreciated and
I'd be glad to provide any clarification if this is confusing.

Thank you,

Marcus Finch
 
M

Marshall Barton

Marcus said:
Okay, so I have a set of forms that are unnecessarily complicated,
referencing other forms and a dozen other things that are just a royal
pain, but my current frustration is selecting a specific value from
the list of a combobox on load. I need the user to be able to change
the value -after- the form loads, but at first that box needs to be
selected and displaying records.

It will be referencing a value on another form that will stay open
behind it to get its own value. Also, the displayed value is not
going to be the data that's passed from the other form because that
data is not necessarily unique, the other forms combobox we're pulling
from has a bound column for the UID and then a display for the user
friendly value which is exactly what I need on this one as well, just
need it autoselected. Any help you can offer would be appreciated and
I'd be glad to provide any clarification if this is confusing.
Click to expand...


Sounds like a real mess. Good luck keeping it together as
you add more and more features ;-\

For this problem, you could just copy the value to combo
box:
Me.combobox = Forms!otherform.othercombo
If you need the combo box's list to be displayed, make it
the first control in the tab list and add the line:
Me.combobox.DropDown
 
M

Marcus Finch

Sounds like a real mess. Good luck keeping it together as
you add more and more features ;-\

For this problem, you could just copy the value to combo
box:
Me.combobox = Forms!otherform.othercombo
If you need the combo box's list to be displayed, make it
the first control in the tab list and add the line:
Me.combobox.DropDown
Click to expand...

Ahhh...brilliant. That does solve the problem. I had hoped to avoid
using Access entirely for this project, but it seems that this is the
best way to go given our current situation and budget soooo... yeah,
thanks for the hopes for fortune, methinks I'll need 'em.
 
Top