combo not putting in table? Also search form question

[d9pierce1]

ProfileNew - Test.zip

Hi all,
This is a two part question!
Attached db, Opens to frmBusiness


First Question:
I am having an issue with getting a combo to put value into a table?
On frmBusiness, Communications tab, Entity Type, cboCategoryEntity, Bound Column is CategoryEntityID


sfrmEntity is based off qryEntityByBusiness.


When I select from drop down, the CategoryEntityID does not go into the tblEntity and I cant figure out why?
Would love some assistance on this.


Second Question:
On my search criteria list box, it there a way to get just one business per entity? Example, If I have one company
with several entities, then it shows up as several businesses! What I would like if possible, is to have just one
business name in list box no matter how many entities it may have per business but still use search criteria to filter the business
if that makes any sense, i do hope it does....
Any assistance would be greatly appriciated!
Thanks
Dave

[ranman256]

In the query,use the FULL path of the combo,either as field,or criteria:

forms!fMyForm!comboBox

Also, be sure of the combo’s bound column. That’s the data the query will use.

[d9pierce1]

Hi ranman256 and thanks
Everything I have done so far comes up with a null value in that combo? Dont get it, after i choose, it should have a value? Correct?
In any event, If I use criteria, what is the format... Forms!frmBusiness!sfrmBusiness.Form.cboCategoryEnt ity but when I put that in
it closes db all together and creates a back up so that is not the correct. The form Is frmBusiness, SubForm is sfrmbusiness, source object is sfrmEntity, and the combo is cboCategoryEntity
Thanks

[davegri]

The combobox works as is for me if I choose twice in succession. Don't know why that would be...

[d9pierce1]

thanks davegri,
I beleive it has something to do with the AddressID as that did work for me also and If I dont put in an address then it gives an error
Not real sure on that. I may need to store addresses differently?
Thanks
Dave

[d9pierce1]

Hi all,
Going to mark this as solved for now. I need to go back and change some things in the forms and tables to make this work.
Thanks for all the assitance.
Dave