Appending the value of a listbox

[Rmoeller]

This seems like it should be easy, but I am stuck! I have a listbox in a form that has a single value. This value is based on the results from a combobox in the same form. I want to than take that listbox value and append it to a table, but I keep getting a null error. Looking this up, I need to access the selected property, but that's where I get confused.

The listbox is called txtScientificName and is found in a Navigation Subform. I can provide more info if needed, I am just not sure what would be helpful.

I am using this in an append query to try and append the value into a table:

 [Forms]![NavfrmEnviroscienceSampleCodes]![NavigationSubform]![txtScientificName] 

[zmbd]

Navigation subform controls are truly wonderful to work with... "bazinga"

you might find this frustration of mine to be helpful
https://bytes.com/topic/access/answe...ol#post3732430

and some more useful tidbits:
https://bytes.com/topic/access/answe...rm#post3771135

So to the meat of the beast.

The Parent form has this:
NavigationControlSubFormContainer
(this would be your ]![NavigationSubform]![)

This is just the container... see my post here that describes the silly thing: https://bytes.com/topic/access/answe...ms#post3760995

So, You open the parent, click on a navigation-subform-control-tab, it loads the associated form.

At this point, ignore everything you've learned about referring to controls on the loaded form within in the navigation subform control... go right for Neopa's suggestion that worked for me in the first link above to refer to the controls on the loaded subform.

NeoPa: (...) try referencing the control name directly and on its own (...)

What you are not telling us is how you are attempting to create your append-query and that may alter how we approach the situation.

-z

[Rmoeller]

Thank you zmbd,

I tried setting the reference control name directly on its own, but that didn't seem to work. I read through the links, but nothing was clicking on that old light bulb....So I stepped away from this for about a week to think about it, and I came up with a work around. I changed the combo box that I wanted populated based on the selection from another combo box to a text box. I then adjusted the query that was the basis for the combo box to include the fields I wanted (basically creating another column for the combo box). Then I used VBA and in the AfterUpdate property of the combo box, I have it update the values of the txt boxes based on the combobox's column(1).

Private Sub cmbAbbreviatedScientificName_AfterUpdate()
Me.cmbScientificName = Me.cmbAbbreviatedScientificName.Column(1)
Me.Refresh
End Sub

Thank you again for the references, Navigation Forms certainly make my head hurt!

R

[zmbd]

That is the truth. (@_@)

Something I've ran in to when working with these, especially the navigation-form-control-buttons (I refuse to call them tabs :) ) is that often when changing a property, the change doesn't take until you save, close, and then re-open the parent navigation form --- keep that in mind if you start experiencing that the parent form isn't working as expected - design-view > save > close > re-open

BOL W/Project

-z