search form

[Allardaccess]

hello,

I have a search form (tissueFilter) . in the form i get the wrong data. i want the names in the form and not the CatID (tbl tcategorie1). i think it's somting with the dependent combobox in form Multi tissue registration. can somebody help me. dependent

 

[liddlem]

Hi Allardaccess
I cant open your db right now, (using Ubuntu at the moment) but I suspect that the combo box is sourcing data from another table.
If you right click on the combo box and choose properties, look in the format tab, Find the properties called "columns" and "column widths"
Set Columns to 2 (or more)
Set "Column Widths" to 0cm;2cm (This says "Hide the value that is in column(0) and show the value is in column(1)

 

[Allardaccess]

Hello,

It isn't the problem with the Combobox. I think it is very diffecult to explain. I try,
1. tbl tissueregistration, from the form multi tissue registration get it his data.
2. in the form multi tissue registration there are 5 combobox (field 1 to 5) they are dependent on each other. Field 1-5 get there data from tbl tcategorie1.
3. tabel tcategorie is working with catid,name(naam)and parentid.
All this is working very good.
but In tbl tissueregistration the catid is registered. when you chenged it to a combo box. in the back ground there is still the catid.
example: when you are making a form from the tbl registration and field 1-5 are not combobox but textbox you see the catid i want to work with the name.

There is a big vba code behind it. maby i whrite it down in the wrong place.

 

[liddlem]

Your database does not have all of the required objects.
Open the relationships manager and then compare this list to the objects that are in the object exp[lorer (on the left hand side)

 

[Allardaccess]

Sorry it dissappeared

 

[liddlem]

Sorry - it still seems to be missing objects.
See attached image.

The objects in the relationships table refers to objects that are NOT in the database (see the object browser on the left.)

Also, the form that you are asking about (Titled "Tissue Registration") opens when I click the "multi registration" button, but the form is NOT in the object browser either.

 

[Allardaccess]

hi,

the problem is that i have hide them. when you puss on all access object then options and show hidden objects.