Please can someone help?

[Sam Summers]

In the attached DB from the view by status button i need to display the Status in the 'StatusVisible' Textbox and the 'Status' Combobox will be hidden.

Two days i have spent and i just cannot fix this.

I really am just not clever enough for this shit so will be packing it all in soon.

Thank you in advance

 

[Minty]

Hi Sam,

You need to filter by StausID not Status as that is the value returned by the combo on View By Status

I can't adjust your forms very easily as you have hidden the nav bar, prevented (easy) design changes, and a whole host of other things in the version you uploaded, that I can't be bothered to workaround to actually provide the fix.

 

[Sam Summers]

Hi Sam,

You need to filter by StausID not Status as that is the value returned by the combo on View By Status

I can't adjust your forms very easily as you have hidden the nav bar, prevented (easy) design changes, and a whole host of other things in the version you uploaded, that I can't be bothered to workaround to actually provide the fix.

Hi Minty,

I will see if i can get my head round this now.
If you use the bypass key you can get to it all

 

[arnelgp]

use Tempvars?

 

[mike60smart]

Hi Sam

This is now fixed. I changed the Status Field in the table "Machines" from a Lookup Field